On Fri, Nov 2, 2012 at 10:18 AM, Simon Davies
<simon.james.dav...@gmail.com>wrote:
> datetime() will give current date and time
> likewise date(), time() etc
>
If I read the original post correctly, I think the OP is requesting a new
function, "now()", that returns the number of seconds since 1970. This
would be the same as "CAST(strftime('%s','now') AS INTEGER)", just easier
to remember.
By coincidence, such a function has already been added to the SQLite
implementation inside of Fossil. See:
http://www.fossil-scm.org/fossil/artifact/b743628236c?ln=669-679
http://www.fossil-scm.org/fossil/artifact/b743628236c?ln=718
Perhaps the OP can simply copy the code above into his own application?
--
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
