On Tue, Apr 19, 2011 at 6:46 PM, Dennis Cote <denn...@harding.ca> wrote:
> 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? > CURRENT_TIMESTAMP is correct. The documentation has been updated. > > -- > Dennis Cote > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
