SQL Language (MOSC)

MOSC Banner

Last_day function for hijrah date (very important please reply as soon as possible)

edited Dec 4, 2012 10:38PM in SQL Language (MOSC) 6 commentsAnswered
Dear All,
I want to get the last day of a Hijrah date, after that I want to see the corresponding Gregorian date.
I am not getting the right answer could you please help me on this.
pls see the following example
 


select
to_date (to_char(sysdate,'dd mm rrrr','nls_calendar=''English Hijrah'''), 'dd mm rrrr') hijrah,
last_day (to_date(to_char(sysdate,'dd mm rrrr','nls_calendar=''English Hijrah'''), 'dd mm rrrr')) lday_hijrah,
last_day(to_date(to_char(sysdate,'dd mm rrrr','nls_calendar=''English Hijrah'''), 'dd mm rrrr')) lday_hijrah,
last_day(to_date(to_char(sysdate,'dd mm rrrr','nls_calendar=''gregorian'''), 'dd mm rrrr')) lday_greg

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center