Re: How does Oracle handle hour ending - hour starting times Need help asap

From: hourman <sdfsd_at_sdfsd.com>
Date: Tue, 17 Jun 2003 13:43:17 GMT
Message-ID: <VVEHa.2159881$uT2.332848@news.easynews.com>

In article <3010975.1055853078_at_dbforums.com>, andrewst <member14183_at_dbforums.com> wrote:
>
>Originally posted by Hourman
>> we get a file every hour 24x7of the loads for the previous hour.

>> any ideas?
>If you want to see 24 rather than 00 for midnight, then either you will
>have to format the time yourself, perhaps in a view, or store it in a
>NUMBER or VARCHAR2 column, not a DATE.
>
>You could format it yourself like this:
>SELECT DECODE(TO_CHAR(timeval,'HH24'),'00','24',TO_CHAR(timeval,-
>'HH24')) FROM ...
>

problem is we need it as a date not as number or varchar

other systems read this data and they are looking for a date field Received on Tue Jun 17 2003 - 08:43:17 CDT