Hi,

is it possible to create a timestamp fild in a table which uses "now" as default if i enter nothing in an insert statement? How can i do this?
Udate: my question was not complete, i dont want to insert UTC, i want to insert my local time

roli

does the SQLite manual give you any pointers?

Hi,

in the documentation i found following: "my_field TIME DEFAULT CURRENT_TIME", which uses UTC. I haven't found anything about local time.

roli

classically you would record date/times in UTC/Zulu Time/GMT
then store the offset to local time.
however the manual infers you can tinker around using local time

Hi,
ok, but this meens to switch the delay twice a year because off summer & winter time.

I read this before, but everything i tried ended with an error.

roli

I'd suggest if local time is requried then you store the time as UTC/GMT and store the local time offset separately
OR
don't bother with Zulu/UTC time.

without knowing what you application is doing its hard to say what is required.

if your application is world wide, spanning several time zones then you may need to take account of local time variations. if its just a time marker its doesn't really matter.

Hi,

i think i found a solution. I created the following trigger:

The only thing that is a bit strange to me is that my trigger don't works if i use "AND start = NULL".