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