Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Converting a Number to a Date

Re: Converting a Number to a Date

From: Regina Harter <rharter_at_emc-inc.com>
Date: Wed, 14 Jun 2000 13:53:44 -0700
Message-Id: <10528.109312@fatcity.com> 





At 12:20 PM 6/14/00 -0800, you wrote:


>I have what appears to be a UNIX-style timestamp series of numbers which I

>have to convert back to dates.

>

>They're in the format 960770731

>

>I've tried a number of things, but haven't figured it out yet.  Has anybody

>encountered something similar?




Looks to me like a julian date with a time attached
YYDDDHHMM


HTH,



Regina


Camarillo, CA
Received on Wed Jun 14 2000 - 15:53:44 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US