PeopleSoft Notes
Blog Archive
►
2014
(2)
►
December
(1)
►
May
(1)
►
2013
(1)
►
June
(1)
►
2012
(1)
►
December
(1)
►
2011
(1)
►
September
(1)
►
2010
(4)
►
October
(1)
►
July
(3)
►
2009
(3)
►
May
(2)
►
April
(1)
▼
2008
(11)
►
April
(1)
►
March
(1)
►
February
(2)
▼
January
(7)
If None(NS_ONB_PERS_STG.ADDRESS1, NS_ONB_PERS_STG....
What is SFTP, and how do I use it?
PeopleCode to limit Search Veiw
Calculating age in Oracle
Scheduling a Process in PeopleCode
Calling an Application Engine from PeopleCode
PeopleSoft blog & user group
►
2007
(18)
►
December
(17)
►
November
(1)
Thursday, January 3, 2008
Calculating age in Oracle
It is more accurate by using MONTH_BETWEEN than 365 day due to leap years:
floor(MONTHS_BETWEEN(to_date($
RptYear
, 'dd-
mon
-
yyyy
'),
BIRTHDATE
)/12)
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment