Hi Marco,
it's true that sqlite seems to manage only epoch time up to seconds
precision: I have my timestamps with microseconds resolution and this is
what I have to do in order to have them in a human readable form:
SELECT COALESCE(datetime(TimeStamp/1000000, 'unixepoch',
'localtime'),'')||'.'||COALESCE((TimeStamp/1000)%1000,'')....
Alessandro
Il 25/06/2015 08.18, Marco Bambini ha scritto:
> Hello I tried to convert an epoch time with a timestamp in milliseconds like
> 1393732179010 to a correct date but it seems like that the function:
> SELECT datetime(1393732179010, 'unixepoch', 'localtime');
> is not able to detect ms resolution and incorrectly reports a negative date.
>
> How can I tell sqlite to interpret timestamp in ms?
> Thanks.
> --
> Marco Bambini
> http://www.sqlabs.com
> http://twitter.com/sqlabs
> http://instagram.com/sqlabs
>
>
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
--
------------------------------------------------------------------------
*Ing. Alessandro Tagliati*
/R/D - Software Projects Manager
/ a.tagliati at selea.com <mailto:a.tagliati at selea.com>
------------------------------------------------------------------------
Selea s.r.l <http://www.selea.com>
V. Aldo Moro, 69
46015 Viadana MN - Italy
<https://www.google.it/maps/place/44%C2%B056%2725.9%22N+10%C2%B028%2757.4%22E/@44.940528,10.482618,194m/data=%213m2%211e3%214b1%214m2%213m1%211s0x0:0x0>
Phone: +390375889091 <tel:+390375889091>
Fax: +390375889080
http://www.selea.com
Questo messaggio e' da ritenersi confidenziale e indirizzato solamente
ai destinatari esplicitamente indicati. Qualora la mail venisse ricevuta
per errore da altri si prega di cancellarla immediatamente e informare
il mittente.
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they are
addressed. If you have received this email by error please delete it and
notify the sender.
------------------------------------------------------------------------
