Member Avatar for pointers

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:MI:SS 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.

  • 3 Contributors
  • 2 Replies
  • 76 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by debasisdas
Member Avatar for jwenting

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

Member Avatar for debasisdas

Check the data foramt by using this

select * from nls_database_parameters

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.