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
select the Julian date for current date.
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;