Currently in Drill there isn't support for 'timestamp with time zone'
data type, all the timestamp/date information is stored in UTC and no
timezone information is maintained, so AFAIK there isn't really a way to
convert dates/timestamp to a specific timezone. However if your input
data contains timezone information Drill should be able to parse the
input and convert it to UTC (if you use the 'z' format specifier).
Thanks
Mehant
On 3/30/15 3:08 PM, Christopher Matta wrote:
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
[email protected]
215-701-3146
