Date Format in Impala

Gayathridevi — Thu, 16 Nov 2017 12:36:41 GMT

Re: Date Format in Impala

Shu_ashu — Thu, 16 Nov 2017 21:41:07 GMT

Instead of cast you need to use from_unixtime

Try the below query will result correct outputs as you are expecting

hive# select from_unixtime(unix_timestamp('161223000001' ,'yyMMddhhmmss'), 'yyyy-MM-dd HH:mm:ss');
+----------------------+--+
|         _c0          |
+----------------------+--+
| 2016-12-23 00:00:01  |
+----------------------+--+

hive# select from_unixtime(unix_timestamp('161223000001' ,'yyMMddhhmmss'), 'yyyy-MM-dd hh:mm:ss');
+----------------------+--+
|         _c0          |
+----------------------+--+
| 2016-12-23 12:00:01  |
+----------------------+--+

question Re: Date Format in Impala in Archives of Support Questions (Read Only)

Date Format in Impala

Re: Date Format in Impala