Re: how to change date format to include time?

 Annabel,

Just add the word 'TIME' in single quotes after the date mask and close the bracket.

Cecil

Annabel Fang Liu wrote in article <5rkgu7$7cu$1_at_nntp.Stanford.EDU>...

>
>Hi,
>
>I am trying to change the date format in oracle 7.3.2 to include
>hour and minute. I would like to change the date format to be
>something like '199901012259'. Can anyone help me?
>
>Thanks.
>
>-Annabel
>
>--
>
Received on Tue Jul 29 1997 - 00:00:00 CDT