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
Messages: 31
Registered: March 2007
Location: Pune,India

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
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



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

Current Time: Fri Apr 28 03:58:02 CDT 2017

Total time taken to generate the page: 0.06386 seconds