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
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 please tell me how
I should go about writing such a trigger. I'd like the [
3 matches
Mail list logo
