Re: [sqlite] DateTime to bigint

2017-12-08 Thread Tibor Balog
] On Behalf Of Paul Sanderson Sent: Friday, 8 December, 2017 10:17 To: SQLite mailing list Subject: Re: [sqlite] DateTime to bigint Hi Tibor Your date format is windows ticks, i.e. 100 nano seconds intervals since 01/01/0001 You can convert it as follows SELECT (StrfTime('%s', '2004-08

Re: [sqlite] DateTime to bigint

2017-12-08 Thread Keith Medcalf
s.sqlite.org] On Behalf Of Paul Sanderson >Sent: Friday, 8 December, 2017 10:17 >To: SQLite mailing list >Subject: Re: [sqlite] DateTime to bigint > >Hi Tibor > >Your date format is windows ticks, i.e. 100 nano seconds intervals >since >01/01/0001 > >You can c

Re: [sqlite] DateTime to bigint

2017-12-08 Thread Tibor Balog
: [sqlite] DateTime to bigint Hi Tibor Your date format is windows ticks, i.e. 100 nano seconds intervals since 01/01/0001 You can convert it as follows SELECT (StrfTime('%s', '2004-08-05') + 62135596800) * 1000 AS Ticks where StrfTime('%s', '2004-08-05') is the number of seconds between

Re: [sqlite] DateTime to bigint

2017-12-08 Thread Paul Sanderson
Hi Tibor Your date format is windows ticks, i.e. 100 nano seconds intervals since 01/01/0001 You can convert it as follows SELECT (StrfTime('%s', '2004-08-05') + 62135596800) * 1000 AS Ticks where StrfTime('%s', '2004-08-05') is the number of seconds between the provided date and 1/1/1970

[sqlite] DateTime to bigint

2017-12-08 Thread Tibor Balog
Hi there, I am very new to SQLite but like it sofar. Run into something couldn’t find an answer may someone can put me in the right direction.. Have an application uses SQLite table with a column “Datum” defined as bigint. I have an identical table with column “Datum” as DateTime “-mm-dd”