Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Converting Numbers to Dates
Allen Kirby wrote:
<snip>
> I won't ask why you didn't store it as a date value in the first
> place. Here's one way (there are others): Take the actual start
> date (Jan. 1 1970 00:00 e.g.) and add seconds/3600 (which is the number
> of days represented by that many seconds). This should work given
<snip>
OK, so I can't multiply. 60 * 60 is 3600, but that is seconds in an hour. divide by 86400 to get number of days. Sorry about that.
-- --- Allen Kirby AT&T ITS Production Services akirby_at_att.com Alpharetta, GA.Received on Tue Mar 18 1997 - 00:00:00 CST