> On 7 Jan 2015, at 2:00pm, MikeSnow <michael.sab...@gmail.com> wrote:
>
> I am kind of new at this..... so if I get you, I should concat the 3 columns
> to get one in the suggested format. But then how do you convert?
>
> "Column_Time"
> 2013-10-07 04:23:19.120-04:00
>
> datetime("Column_Time", 'utc')?
SELECT datetime( strftime(ReceiveDate ||' '|| Timezone) )
might do what you want. Unfortunately I don't know of anything that can
understand timezone initials like 'EST'.
Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
