Interview Answer

Debugging is twice as hard as writing the code in the first place. Therefore, if you write the code as cleverly as possible, you are–by definition–not smart enough to debug it. Brian Kernighan

How to get Julian date Oracle

April 12, 2016 7:25 pm

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.