Date/Time issues 1

[millzy7]

Hi

I have a date field but all i am interested in is the time element ie HH:MM:SS.

How can i insert into this field a time of 00:45:00.

Also how can i retrieve just the time element from the date field?

Thanks

 

[lewisp]

To create a time in a date field use

[tt]To_Date('00:45:00','HH24:MI:SS')[/tt]

To read the time back from the field use

[tt]To_Char(date_field,'HH24:MI:SS')[/tt]

 

[millzy7]

Thanks lewisp! Works perfect