[prev in list] [next in list] [prev in thread] [next in thread]
List: sqlite-users
Subject: Re: [sqlite] =?utf-8?q?converting_unix10_and_unix13_dates_in_the_same?=
From: Tim Streater <tim () clothears ! org ! uk>
Date: 2016-09-29 13:36:00
Message-ID: 20160929133639.D4DCDA374 () sqlite ! org
[Download RAW message or body]
On 29 Sep 2016 at 14:14, Paul Sanderson <sandersonforensics@gmail.com> 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
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic