This week's book giveaway is in the OCAJP forum.
We're giving away four copies of OCA Java SE 8 Programmer I Study Guide 1Z0-808 and have Jeanne Boyarsky & Scott Selikoff on-line!
See this thread for details.
The moose likes Oracle/OAS and the fly likes What is the default format model string for timestamp in Oracle. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA Java SE 8 Programmer I Study Guide 1Z0-808 this week in the OCAJP forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "What is the default format model string for timestamp in Oracle." Watch "What is the default format model string for timestamp in Oracle." New topic
Author

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

Mahtab Alam
Ranch Hand

Joined: Mar 28, 2012
Posts: 339

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.


http://www.mahtabalam.net , Oracle Java Programmer , Oracle SQL Expert , Oracle Java Web Component Developer
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2526
    
  10

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.


OCUP UML fundamental and ITIL foundation
youtube channel
 
Don't get me started about those stupid light bulbs.
 
subject: What is the default format model string for timestamp in Oracle.