I have a column that’s UTC, how can I convert this column to a specific
timezone?


> select to_timestamp(columns[13], 'YYYY-MM-dd HH:mm:ss') as `datetime_utc` 
> from `weather/2012` limit 10;
+--------------+
| datetime_utc |
+--------------+
| 2012-02-01 05:54:00.0 |
| 2012-02-01 06:54:00.0 |
| 2012-02-01 07:54:00.0 |
| 2012-02-01 08:54:00.0 |

Chris Matta
cma...@mapr.com
215-701-3146
​

Reply via email to