Re: [sqlite] wrong timestamp using strftime('%s')

, 2019 14:49 >To: 'SQLite mailing list' >Subject: Re: [sqlite] wrong timestamp using strftime('%s') > >the type of CreationDate is integer. >The CreationDate is inserted with strftime('%s', '1970-01-01 >00:00:00.000') > >need to check which value is written to the database. >I

Re: [sqlite] wrong timestamp using strftime('%s')

...@mailinglists.sqlite.org] Im Auftrag von Keith Medcalf Gesendet: Montag, 25. November 2019 22:41 An: SQLite mailing list Betreff: Re: [sqlite] wrong timestamp using strftime('%s') -- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic

Re: [sqlite] wrong timestamp using strftime('%s')

-- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. On Sunday, 24 November, 2019 13:21, Dominik Ohnezeit wrote: >I am trying to convert a date to timestamp, but after the conversion with >strftime('%s') the integer result

Re: [sqlite] wrong timestamp using strftime('%s')

Dominik Ohnezeit, on Sunday, November 24, 2019 03:21 PM, wrote... > strftime('%s', '1970-01-01 00:00:00.000') [clip] > 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? Here are some samples run... sqlite> select strftime('%s',

Re: [sqlite] wrong timestamp using strftime('%s')

On 11/24/19, Dominik Ohnezeit wrote: > > strftime('%s', '1970-01-01 00:00:00.000') Returns '0'. > > datetime(CreationDate, 'unixepoch') Assuming CreationDate is 0, this returns '1970-01-01 00:00:00'. > > Does anyone know why? > Dunno why you might be getting anything different. -- D.

[sqlite] wrong timestamp using strftime('%s')

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