Julian date is calculated from bc 1400 or some thing. Substract the difference 2378850 from the function. That will give you. 76317
regards Gopa On Dec 3, 2010 10:45 PM, "Ronnie Smith" <ronnie.smith...@gmail.com> wrote: That is the right idea, but it is not returning the correct julian for us. This one returns 2455167 for the date I posted and we should be seeing 76,317. Thanks! On Fri, Dec 3, 2010 at 11:53 AM, Gopakumar Pandarikkal <pandarik...@gmail.com> wrote: > You mean co... -- Ronnie D Smith Jr IT Department Rose Acre Farms Phone (812) 497-2557 ext 290 rsm...@goodegg.com -- ... -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en