Message-Id: <10576.113476@fatcity.com> From: dgoulet@vicr.com Date: Tue, 1 Aug 2000 09:31:59 -0400 Subject: Re:Julian date problem Vipul, You need to break up the data into a time and date component. Julian date format does not include date. It's a problem that I have with out automatic test equipment where they report the date in Julian date & the time in clock ticks (Don't Ask, I did not write it). Thankfully they hand it over as two separate fields so that before inserting we can process it as follows: to_date(:jdate,'J')+((:clock_ticks/18.206482)/86400) Dick Goulet ____________________Reply Separator____________________ Subject: Julian date problem Author: vipul desai Date: 8/1/00 2:28 AM hi there, is there any way to insert a date field having number like 123456789012345678 Julian Date. means i have 18 digit number whcih is in julian date having time up to micro sec. i want to insert the same into the table but it gives me error conversion complets any idea on the same. thanks in advance, -Vipul ____________________________________________________________________ Get free email and a permanent address at http://www.netaddress.com/?N=1 -- Author: vipul desai INET: desaivipul@usa.net Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).