Re: [sqlite] converting unix10 and unix13 dates in the same column

sqlite-users-boun...@mailinglists.sqlite.org] > On Behalf Of Paul Sanderson > Sent: Thursday, 29 September, 2016 07:51 > To: SQLite mailing list > Subject: Re: [sqlite] converting unix10 and unix13 dates in the same > column > > All sorted now thank you >

Re: [sqlite] converting unix10 and unix13 dates in the same column

All sorted now thank you ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] converting unix10 and unix13 dates in the same column

On 29 Sep 2016 at 14:14, Paul Sanderson 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

Re: [sqlite] converting unix10 and unix13 dates in the same column

ehalf Of Paul Sanderson >> Sent: Thursday, 29 September, 2016 07:14 >> To: General Discussion of SQLite Database >> Subject: [sqlite] converting unix10 and unix13 dates in the same column >> >> I have a table with dates in different formats, either 10 digit or 13 >>

Re: [sqlite] converting unix10 and unix13 dates in the same column

ect: [sqlite] converting unix10 and unix13 dates in the same column I have a table with dates in different formats, either 10 digit or 13 digit unix dates 1234345087123 1234567890 1432101234 1456754323012 I want a sql query that will convert both dates, I tried this SELECT CASE dt WHEN (un

Re: [sqlite] converting unix10 and unix13 dates in the same column

always taken. > -Original Message- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > On Behalf Of Paul Sanderson > Sent: Thursday, 29 September, 2016 07:14 > To: General Discussion of SQLite Database > Subject: [sqlite] converting unix10 and unix13 dates in the s

[sqlite] converting unix10 and unix13 dates in the same column

I have a table with dates in different formats, either 10 digit or 13 digit unix dates 1234345087123 1234567890 1432101234 1456754323012 I want a sql query that will convert both dates, I tried this SELECT CASE dt WHEN (unix10and13.dt < 100) THEN DateTime(unix10and13.dt,