Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Date Columns
You don't choose the way to store a date. You choose the way you want the date presented when you do a select.
To create the date column:
Create Table XTable (
DateColumn DATE
)
When you want to view the date in the format you asked, it would be:
SELECT to_char(datecolumn,'MM/DD/YYYY') FROM xtable; Received on Wed Oct 13 1999 - 00:00:00 CDT