Hi,

I have a question. Please help me out.

What is the default "display date format" and default internal "accepting date format"? How to change the default display and accepting format. In my system, the default display date format in sql * plus is dd-mon-yy, where as in toad it is mm/dd/yyy HH:MIS AM

Can we change these two default display date format.I know I can use to_char. But without any explicit conversion functions during the selection.

insert into mine_date values(to_date('22/03/1984','dd/mm/yyyy'))

What is the internal date format of the date(22/03/1984)that has been changed by to_date function.

Oracle stores dates as numbers, the display format is ALWAYS determined by the client, not the server.

Check the data foramt by using this

select * from nls_database_parameters