CREATE TABLE test (.. createData DATETIME DEFAULT CURRENT_TIMESTAMP)
On 12/13/07, Joanne Pham <[EMAIL PROTECTED]> wrote:
> Hi All,
> I create the table as :
> create table test (name varchar(30), createDate DATE default
> DATETIME('NOW'));
> but I got the error message. I want to have the default as now if it is not
> specify.
> Thanks in advance,
> Joanne
>
>
>
> ____________________________________________________________________________________
> Never miss a thing. Make Yahoo your home page.
> http://www.yahoo.com/r/hs
--
Puneet Kishor
http://punkish.eidesis.org/
Nelson Institute for Environmental Studies
http://www.nelson.wisc.edu/
Open Source Geospatial Foundation (OSGeo)
http://www.osgeo.org/
Summer 2007 S&T Policy Fellow, The National Academies
http://www.nas.edu/
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
