Re: format for timestamp

From: Randy Harris <randy.harris_at_nospam.net>
Date: Tue, 19 Feb 2002 06:39:37 GMT
Message-ID: <Jqmc8.6982$pC1.1277542@newssrv26.news.prodigy.com>

Perfect! Thanks

"Bricklen" <bricklenREMOVETHIS_at_shaw.ca> wrote in message news:3C71D471.157D6515_at_shaw.ca...
> 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 Tue Feb 19 2002 - 00:39:37 CST