Win a copy of Kotlin in Action this week in the Kotlin forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

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

 
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: 2632
17
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.
 
Don't get me started about those stupid light bulbs.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!