Home » SQL & PL/SQL » SQL & PL/SQL » Defining Date Format while creation table (Oracle 9i/10g)
icon8.gif  Defining Date Format while creation table [message #324589] Tue, 03 June 2008 04:23 Go to next message
sumedh7
Messages: 31
Registered: March 2007
Location: Pune,India
Member
Hi,

Can we set specific date format while creating table for date datatype Column.


Thanx in advance
Re: Defining Date Format while creation table [message #324594 is a reply to message #324589] Tue, 03 June 2008 04:30 Go to previous message
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
As the word date format implies it is meant for output and not for input. You don't need to worry how oracle stores the date internally. If you want it in a particular format then refer the following link

http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/sql_elements004.htm#i34924

Regards

Raj
Previous Topic: NESTED TABLE in table column
Next Topic: Optimized Database Creation
Goto Forum:
  


Current Time: Sat Dec 10 03:10:11 CST 2016

Total time taken to generate the page: 0.05076 seconds