Re: why it has error ?
From: Vladimir M. Zakharychev <bob_at_dpsp-yes.com>
Date: Fri, 28 Dec 2001 18:32:13 +0300
Message-ID: <a0i34m$e6c$1_at_babylon.agtel.net>
Date: Fri, 28 Dec 2001 18:32:13 +0300
Message-ID: <a0i34m$e6c$1_at_babylon.agtel.net>
try this:
......
column_1 date default to_date('2001/01/01','YYYY/MM/DD')
......
or whatever the correct date format is (it's hard to tell if it's MM/DD or DD/MM from 01/01 :)
-- Vladimir Zakharychev (bob_at_dpsp-yes.com) http://www.dpsp-yes.com Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications. All opinions are mine and do not necessarily go in line with those of my employer. "cok" <nielonghai_at_cannac.com.cn> wrote in message news:a0ghgn$atr$1_at_mail.cn99.com...Received on Fri Dec 28 2001 - 16:32:13 CET
> 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 ?
>
>
>
>