Re: 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
>

SELECT TO_CHAR(sysdate,'HH24:MI:SS')
  FROM DUAL;

--
Noel