Hello,
it is a common practice to store datetime values as UNIX time UTC.
Maybe, Sqlite should have some shortcut for evaluating current moment?
Some alias for strftime('%s','now') ? Like, "now" or "unixnow":
created_at DEFAULT (now()) vs created_at DEFAULT
(strftime('%s','now'))
It is shorter and more important - it can be written without consulting docs
for strfime() , I cannot remember parameters (
Regards,
Grigory Grigorenko
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
