Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

What is the default format model string for timestamp in Oracle.

 
Mahtab Alam
Ranch Hand
Posts: 391
1
Java MySQL Database PHP
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I want to know what is the default format model string for timestamp.

Like for Date type we have 'DD-MON-RR'
What is for Timestamp type.
 
Jan Cumps
Bartender
Posts: 2588
11
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Mahtab,
There is no default format string for date and for timestamp. It is dependent on the location settings.
Your date, that might look as 21-OCT-2014 for you, will show 21-OKT-2014 for me.
Have a look at oracle's NLS documentation to see how language and country settings can influence date and number formats.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic