Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> extract just the time from a date time field
Looking for a function that will extract just the time from a date time field.
Example:
02/19/2004 12:05:32
I tried to use trim-trailing but it wont' let me do it on a date field. I want to extract just 12:05:32
Thanks! Received on Fri Mar 12 2004 - 10:42:53 CST