Hello,
I am trying to convert a date to timestamp, but after the conversion with
strftime('%s') the integer result is wrong
Example:
I insert a integer timestamp into a integer table column named CreationDate
with
strftime('%s', '1970-01-01 00:00:00.000')
After getting it from the table with
datetime(CreationDate, 'unixepoch')
or
datetime(CreationDate)
the date I get back is not 1970-01-01 00:00:00.000 but 1969-12-31
22:29:11.000
Does anyone know why?
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
