hi list
in other DBs one can create time stamp column with
CREATE TABLE todo (
id serial primary key,
title text,
created timestamp default now(),
done boolean default 'f'
);
I thought this was fixed. Which version do you have?
The DEFAULT constraint specifies a default value to use when doing an
INSERT. The value may be NULL, a string constant or a number. Starting
with version 3.1.0, the default value may also be one of the special
case-independant keywords CURRENT_TIME, CURRENT_DATE or
CURRENT_TIMESTAMP. If the value is NULL, a string constant or number,
it is literally inserted into the column whenever an INSERT statement
that does not specify a value for the column is executed. If the value
is CURRENT_TIME, CURRENT_DATE or CURRENT_TIMESTAMP, then the current
UTC date and/or time is inserted into the columns. For CURRENT_TIME,
the format is HH:MM:SS. For CURRENT_DATE, YYYY-MM-DD. The format for
CURRENT_TIMESTAMP is "YYYY-MM-DD HH:MM:SS".
http://sqlite.org/lang_createtable.html
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------