Re: Date Columns

The standard format for the "DATE" datatype is "01-DEC-99". I think its the internal format that oracle uses.
You can set the environment variable "NLS_DATE_FORMAT" to "MM/DD/YYYY". Then even an "select sysdate from dual" should bring you the wanted format.

Andreas Köster

Brandon Duncan schrieb:

> Does anyone know the correct syntax to get a Date Column in the format
> 'MM/DD/YYYY' (01/01/1999)?
>
> I'm using
> Create Table XTable (
> DateColumn DATE (10, 'MM/DD/YYYY'),
> ......
>
> I get an error message, 'Missing right parenthisis."
>
> Any ideas?
>
> Brandon
Received on Fri Oct 15 1999 - 01:02:31 CDT