Re: Date Columns

On Thu, 14 Oct 1999 10:46:52 -0400, "Brandon Duncan" <BDuncan_at_PIETECHNET.com> wrote:

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

Just create the table with :-

CREATE TABLE xtable (
 DateColumn DATE,
.... );

And then format the column when you perform a selection :-

SELECT to_char(DateColumn,'MM/DD/YYYY') from xtable;

Jason. Received on Thu Oct 14 1999 - 12:32:48 CDT