[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: Convert julian date

If you are in an Oracle environment, you can obtain the julian date by
using the format mask 'J' with functions on date data.
TO_CHAR(date, 'J').

Also, there is an SQC at http://www.sqrug.com/~ftp/datefunc.sqc written by
Robert Goshko which has a Julian Date procedure.

Michael K. Lee
mlee@agconsult.com
Consultant
AG Consulting, an ADP Company
http://www.agconsult.com





Vicki Lo <VLo@DATASTUDYINC.COM> on 09/23/98 04:39:12 PM

Please respond to SQR-USERS@USA.NET

To:   Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
cc:    (bcc: Michael Lee/Application Group)
Subject:  Convert julian date




Hello everyone;

Does anyone has the sqc to convert the calendar date to julian date?
For example, the julian date for September 19, 1993 is 93262.
Please send me a copy if you have one. Thank you.

Vicki