Re: how to change date format to include time?

From: Tim Witort <trwAT_at_ATmedicalert.DOTorg>
Date: 1997/07/29
Message-ID: <33DE7A28.801@ATmedicalert.DOTorg>#1/1

Annabel Fang Liu wrote:
>
> 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?

TO_CHAR(dateCol,'YYYYMMDDHH24MI')

TRW -- ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| | Tim Witort || He is not silent. He is not | | trwATmedicalertDOTorg || whispering. We are not quiet | | || we are not listening. | | Pin: TZ, only one :^( || - Out of the Grey | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||

Received on Tue Jul 29 1997 - 00:00:00 CDT