Re: [sqlite] create table with datatype = DATE

[T&B]

Hi Joanne,

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.

create table Test (Name text, createDate Date default current_date);

Tom


-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------