Hi,
On the page http://www.sqlite.org/lang_createtable.html
The following text appears:
* If the default value of a column is CURRENT_TIME, CURRENT_DATE or
CURRENT_DATETIME, then the value used in the new row is a text
representation of the current UTC date and/or time. For CURRENT_TIME,
the format of the value is "HH:MM:SS". For CURRENT_DATE, "YYYY-MM-DD".
The format for CURRENT_TIMESTAMP is "YYYY-MM-DD HH:MM:SS".
The first sentence uses the name CURRENT_DATETIME (hooray), the fourth
uses the name CURRENT_TIMESTAMP (booo) for what I believe are supposed
to be the same thing.
Which of these is the correct name, or are they equivalent?
--
Dennis Cote
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
