On 29 Sep 2016 at 14:14, Paul Sanderson <[email protected]> wrote: 

> I have a table with dates in different formats, either 10 digit or 13
> digit unix dates
>
> 1234345087123
> 1234567890
> 1432101234
> 1456754323012

Are these strings or numbers? What is your SQL to get these into the table and 
what is the schema for dt?

(Me, I convert all dates into seconds-since-the-epoch, never had a problem).



--
Cheers  --  Tim
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to