] 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
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
: [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
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
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”
5 matches
Mail list logo