Bow!
that's what I call 'service' !
I was looking for a good day for this and nothing habe poped up only for the
reverse task.
You made my day!
Thank You Sir.
-----Ursprüngliche Nachricht-----
From: Paul Sanderson
Sent: Friday, December 8, 2017 6:16 PM
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-05') + 62135596800) * 10000000 AS Ticks
where StrfTime('%s', '2004-08-05') is the number of seconds between the
provided date and 1/1/1970
62135596800 is the difference in seconds between 1/1/1970 and 1/1/0001
and 10000000 converts it to nanoseconds
HTH
Paul
www.sandersonforensics.com
skype: r3scue193
twitter: @sandersonforens
Tel +44 (0)1326 572786
http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit
-Forensic Toolkit for SQLite
email from a work address for a fully functional demo licence
On 8 December 2017 at 16:53, Tibor Balog <tibor.ba...@gmx.ch> wrote:
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 “yyyy-mm-dd”
How can I convert this column -preferable in place- to bigint?
Some more info:
“2004-08-05” should be converted to “632272608000000000” .
Thank You,
in advence.
(Tibor)
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
