Fri, 2 Nov 2012 10:25:18 -0400 от Richard Hipp <d...@sqlite.org>:
>
>
>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.
Correct!
>
>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?
>
I'm using Delphi with sqlite3.dll, maybe I should introduce my own function.
>
>--
>D. Richard Hipp
>d...@sqlite.org
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
