Just in case you also run into this: I had to do this recently on a
project of mine and found out that datetime('now') (on Windows)
doesn't give me the actual time since it uses UTC. To get the actual
local time, use datetime('now','localtime').
For the rest of the date/time documentation, you can
On 10/17/08, Kristofer Hindersson <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I've recently started to play around with SQLite and I'm currently trying to
> create a trigger for updating a timestamp field inside a table (SQL-syntax
> for the creation of the table is included below.) Could someone pleas
2 matches
Mail list logo
