Oracle DATE/TIME default format

From: <ivoly_at_my-deja.com>
Date: Wed, 08 Sep 1999 22:59:26 GMT
Message-ID: <7r6po7$89d$1@nnrp1.deja.com>

I have some problems with Oracle DATE data type. I need the data format to be like
MON/DD/YYYY HH:MI:SS AM rather than DD-MON-YY (which is the default format).
When I run "alter session set nls_date_format = 'MON/DD/YYYY HH:MI:SS AM';"
and after that run

insert into table_name
values ('5','3','o','Mar 11 1999 1:22:33 AM');

The command executed successfully.

the result is:

select *
from table_name

ID COL_1 COL_2 DATE_TIME 5 3 o 03/11/1999

As you can see the last row is showing only the DATE but not the TIME as I specified above.

Any suggestions ???

Also can I change the default DATE format to include and time values as well?

Thanks

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Sep 08 1999 - 17:59:26 CDT