Interview Answer

Measuring programming progress by lines of code is like measuring aircraft building progress by weight. Bill Gates

How to get Julian date Oracle

January 1, 1970 12:00 am

Comments



How to get Julian date Oracle


select the Julian date for current date.


Solution

   					 
												SQL > select to_char(sysdate,J) as julian from dual; 

												-- Convert date to Julian date 
												SQL > select to_char(to_date(24-Jan-2013?,dd-mon-yyyy),J) as julian from dual;
												SQL > select to_char(to_date(01-Jan-4712 BC,dd-mon-yyyy AD),J) as julian from dual;
																    

Comments



Please login to add comments.