aspose file tools*
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
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: 319

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: 2516
    
  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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: What is the default format model string for timestamp in Oracle.