[sqlite] Epoch time with timestamp in ms

2015-06-25 Thread Alessandro Tagliati
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/100, 'unixepoch', 'localtime'),'')|

[sqlite] Epoch time with timestamp in ms

2015-06-25 Thread Marco Bambini
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 s

[sqlite] Epoch time with timestamp in ms

2015-06-25 Thread Richard Hipp
On 6/25/15, Alessandro Tagliati wrote: > 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(Ti

[sqlite] Epoch time with timestamp in ms

2015-06-25 Thread Richard Hipp
On 6/25/15, Marco Bambini wrote: > 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 r