Interview Answer

Good code is its own best documentation. As you are about to add a comment, ask yourself, How can I improve the code so that this comment isn't needed? Improve the code and then document it to make it even clearer. Steve McConnell

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.