REPOST: Re: why it has error ?
From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 29 Dec 2001 22:05:16 +0100
Message-ID: <4$--$$-$-_$-%-%%_$_at_news.noc.cabal.int>
Date: Sat, 29 Dec 2001 22:05:16 +0100
Message-ID: <4$--$$-$-_$-%-%%_$_at_news.noc.cabal.int>
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
- WAS CANCELLED BY =======: Path: news.uni-stuttgart.de!dns.phoenix-ag.de!newsfeed01.sul.t-online.de!newsfeed00.sul.t-online.de!t-online.de!skynet.be!skynet.be!newspeer.radix.net!uunet!ash.uu.net!sac.uu.net!lax.uu.net!news.navix.net!u.n.a.c.4.n.c.3.l.l.e.r From: Sybrand Bakker <postbus_at_sybrandb.demon.nl> Newsgroups: news.admin.censorship,alt.test,comp.databases.oracle.tools Subject: cmsg cancel <ivbs2uodjc3e683p3tubp0bjk8i5je1st9_at_4ax.com> Control: cancel <ivbs2uodjc3e683p3tubp0bjk8i5je1st9_at_4ax.com> Date: Wed, 2 Jan 2002 04:58:40 GMT Organization: Navix Internet Subscribers Lines: 2 Message-ID: <cancel.ivbs2uodjc3e683p3tubp0bjk8i5je1st9_at_4ax.com> NNTP-Posting-Host: 166.102.15.34 X-Trace: iac5.navix.net 1009948135 29203 166.102.15.34 (2 Jan 2002 05:08:55 GMT) X-Complaints-To: abuse_at_navix.net NNTP-Posting-Date: 2 Jan 2002 05:08:55 GMT X-No-Archive: yes Comment: Dude, where's my NewsAgent? Xref: news.uni-stuttgart.de control:40287063
autocancel Received on Sat Dec 29 2001 - 22:05:16 CET