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: Optimized Database Creation
Next Topic: Sql query
Goto Forum:
  


Current Time: Sun Aug 20 10:36:10 CDT 2017

Total time taken to generate the page: 0.08676 seconds