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')? -- View this message in context: http://sqlite.1065341.n5.nabble.com/Time-Zone-Conversions-tp79849p79865.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users