Re: [sqlite] Update Statements using Sub query

thanks Simon -- View this message in context: http://sqlite.1065341.n5.nabble.com/Update-Statements-using-Sub-query-tp80175p80181.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] Update Statements using Sub query

I was wondering if anyone could help I am trying to use Excel to create update statements based on certain criteria. For example...this works UPDATE CDR_Adjusted SET "DateTime"=DATE||" "||TIME; (This is what I need, a simple Concat 2013-10-11 7:59 But when I try to do this UPDATE

Re: [sqlite] Error while executing query: no such column: t1.*B.Switch-Tower-Sector

I got it...so happy, thanks guys -- View this message in context: http://sqlite.1065341.n5.nabble.com/Error-while-executing-query-no-such-column-t1-B-Switch-Tower-Sector-tp79905p79930.html Sent from the SQLite mailing list archive at Nabble.com. ___

[sqlite] Error while executing query: no such column: t1.*B.Switch-Tower-Sector

I was wondering if anyone could let me know where I am going wrong. I am getting the error... "Error while executing query: no such column: t1.*B.Switch-Tower-Sector" but, the column, t1.[*B.Switch-Tower-Sector], does exist. I get results when I do select[*B.Switch-Tower-Sector] from t1; but an

Re: [sqlite] Time Zone Conversions

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:

[sqlite] Time Zone Conversions

As I look through the posts, i dont see what I am looking for. I am trying to create a CASE statement that converts time zones to UTC for db storage. For example, I have 3 columns, ReceiveDate, Timezone, UTC Datetime. 04/11/2014 2:00:00, EST, I would like to update UTC Datetime with logic