Format date in HIVE

ating28 — Thu, 27 Sep 2018 10:31:47 GMT

Hello, how do you format date like this in HIVE ?

from:

Tue Sep 26 22:02:11 CDT 2018

to:

2018-09-26 22:02:11

I've tried different format specifier but didn't work. I must have done something wrong. Any help would be helpful. Thanks

Re: Format date in HIVE

Shu_ashu — Thu, 27 Sep 2018 20:17:41 GMT

@A C

To change the format of the input time we need to use unix_timestamp along with from_unixtime funcitons.

Try with below syntax

hive> select from_unixtime(unix_timestamp("Tue Sep 26 22:02:11 CDT 2018",'EEE MMM dd HH:mm:ss z yyyy'),'yyyy-MM-dd HH:mm:ss');
+----------------------+--+
|         _c0          |
+----------------------+--+
| 2018-09-26 22:02:11  |
+----------------------+--+

If the Answer helped to resolve your issue, Click on Accept button below to accept the answer, That would be great help to Community users to find solution quickly for these kind of issues.

question Format date in HIVE in Archives of Support Questions (Read Only)

Format date in HIVE

Re: Format date in HIVE