Re: Stripping Time from Date.

From: Prasad Pelala <ppel_at_gwl.com>
Date: Fri, 04 Jun 1999 12:35:14 -0600
Message-ID: <37581C62.CA524863@gwl.com>

Assuming the field you want to hold "time only" is a char datatype you can use the to_char function

to_char(<my_date>, 'hh24miss')

Hope this helps,
Prasad.

grider22_at_my-deja.com wrote:
>
> Hi,
>
> I have a field that holds only time...length of 6 (i.e. HH24MISS). How
> would I strip just the time off of a date (YYYYMMDDHH24MISS) and derive
> it into the time field. Trunc and Round doesn't seem to be working for
> me using 'HH24MISS' as a mask. Any suggestions?
>
> Thanks,
> Stephen
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Fri Jun 04 1999 - 13:35:14 CDT