Re: how to change date format to include time?

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

It looks like you want 'yyyymmddhh24mi'

alter session set nls_date_format = 'yyyymmddhh24mi'; or
dbms_session.set_nls( 'nls_date_format', '''yyyymmddhh24mi''' );

-- 
Tomm Carr
--
"Can you describe your assailant?"
"No problem, Officer.  That's exactly what I was doing when he hit me!"