The best programmers are not marginally better than merely good ones. They are an order-of-magnitude better, measured by whatever standard: conceptual creativity, speed, ingenuity of design, or problem-solving ability. Randall E. Stross
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;