Meaningless Drivel is fun!*
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 Murach's Java Servlets and JSP this week in the Servlets 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: 222

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.


Oracle Java Programmer , Oracle SQL Expert
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2491
    
    8

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
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: What is the default format model string for timestamp in Oracle.
 
Similar Threads
change data type from string to timestamp
Need to update date from jsp to mysql database.
Oracle Timestamps and java.
Changing Timestamp of HtmlLayout of log4j
Delay of 5 minutes and 40 seconds