whalesong:~ brunij$ date
Thu Jul 21 13:40:42 MST 2005
whalesong:~ brunij$ sqlite3 /dev/null 'select current_time'
20:40:44
It works for me. I'm located at GMT-7. Where are you?
Perhaps what you wanted was:
select datetime('now','localtime');
On Jul 21, 2005, at 1:32 PM, Cyril Scetbon
Hello,
In the documentation for column constraints, there is an option called
"default" which could take the text "current_timestamp" as its value.
Supposedly, this will populate the column with the current time and
date. However, when I attempt to use this, my column is simply
populated with
2 matches
Mail list logo