PeopleSoft Help
PeopleCode, Integration Broker, Application Server
Thursday, March 29, 2012
LeapYear SQL
SELECT
CASE
WHEN
(
SELECT
Extract
(
DAY
FROM
Last_day
(
To_date
(
'0201'
||
Extract
(
YEAR
FROM
SYSDATE
)
,
'mmddyyyy'
)
)
)
FROM
dual
)
=
'29'
THEN
'LeapYear'
ELSE
'Not A Leap Year'
END
FROM
dual
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment