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