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