Re: format for timestamp

select to_char(sysdate,'DD/MON/YYYY HH24:MI:SS') from dual;

(replace the the column and table)

Randy Harris wrote:
>
> Does the timestamp# field in sys.aud$ contain time as well as date
> information? If so, how can I format it to display?
>
> --
> Randy Harris
Received on Mon Feb 18 2002 - 22:30:37 CST