SQL Help regarding time zone offsets (no replies)
(MySQL.com) Trying to automatically convert from UTC to central time taking into account daylight savings time. I've got this in my WHERE clause to make the shift (either 5 or 6 hours difference), but I'm getting an error. Apparently the CONVERT_TZ function d
Update update feed set failed_fetches=0, fetched=current_timestamp() where feed_id = 1268 failed: 1142 [UPDATE command denied to user '334187_hdlns_ms5'@'10.187.248.89' for table 'feed'] in [update feed set failed_fetches=0, fetched=current_timestamp() where feed_id = 1268]
updated 1268 (MySQL User Forums), inserted 30, updated 0, at 2012-06-02 00:11:03