Re: TimeStamps

From: Chris Nelson <ChrisNelson_at_eaton.com>
Date: Tue, 22 Jun 1999 22:48:29 -0400
Message-ID: <37704AFC.686FB2D@eaton.com>

Howdy.

The date type also contains a time component. You can display it with: TO_CHAR( date_type_column, 'mm/dd/yyyy hh24:mi:ss')

to show time in 24-hour format, or you could omit the day portion, with:

TO_CHAR( date_type_column, 'hh12:mi:ss')

for only 12-hour time format. Of course, you could substitute 12-hour and 24-hour formats at will in these examples.

Chris

MLQ wrote:

> I need to display date and time in a column in my D/B. Is
> there such a type in Oracle and can I Display them together
> in the same column. Ie. dd/mm/yy hh:mm:ss (Or something
> similar).
>
> Thanks
Received on Tue Jun 22 1999 - 21:48:29 CDT