Re: why it has error ?
From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 29 Dec 2001 22:05:16 +0100
Message-ID: <ivbs2uodjc3e683p3tubp0bjk8i5je1st9_at_4ax.com>
Date: Sat, 29 Dec 2001 22:05:16 +0100
Message-ID: <ivbs2uodjc3e683p3tubp0bjk8i5je1st9_at_4ax.com>
On Fri, 28 Dec 2001 23:30:17 +0100, "Stjepan Brbot" <Stjepan.Brbot_at_ZG.HiNet.HR> wrote:
>"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".
Nonsense and you are using MMM where it should been MON
Regards
Sybrand Bakker, Senior Oracle DBA
To reply remove -verwijderdit from my e-mail address Received on Sat Dec 29 2001 - 22:05:16 CET