Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> extract just the time from a date time field

extract just the time from a date time field

From: Chuck C <chucker8_at_rogers.com>
Date: 12 Mar 2004 08:42:53 -0800
Message-ID: <cc8d053c.0403120842.1795fe6f@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US