Re: why it has error ?
From: Stjepan Brbot <Stjepan.Brbot_at_ZG.HiNet.HR>
Date: Fri, 28 Dec 2001 23:30:17 +0100
Message-ID: <a0l3sh$4nsa$2_at_as201.hinet.hr>
Date: Fri, 28 Dec 2001 23:30:17 +0100
Message-ID: <a0l3sh$4nsa$2_at_as201.hinet.hr>
[Quoted] "cok" <nielonghai_at_cannac.com.cn> wrote in message
news:a0ghgn$atr$1_at_mail.cn99.com...
> hi ,
>
> This is my SQL sentence :
>
>
> create table MyTable
> (
> column_1 date default '2001/01/01'
> )
>
> but it has error about:
>
> default '2001/01/01'
>
> why ?????
>
> what can I do ?
You have to define date in original Oracle format "DD-MMM-YYYY" like "01-JAN-2001".
-- Stjepan Brbot <Stjepan.Brbot_at_ZG.HiNet.HR>Received on Fri Dec 28 2001 - 23:30:17 CET