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

Home -> Community -> Usenet -> c.d.o.server -> Re: Converting Numbers to Dates

Re: Converting Numbers to Dates

From: Allen Kirby <akirby_at_att.com>
Date: 1997/03/18
Message-ID: <332EC7D4.3A86@att.com>#1/1

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

Original text of this message

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