CODEWITHSUNDEEP
sqldateformathive
nagarjuna
nagarjuna

Reputation: 37

how to covert string datatype to date datatype in HIVE?

I have a date in string format in hive table (like "20121021") How do I convert this into "yyyy-mm-dd" (ex: 2012-10-21 or 2012/10/21)?

Upvotes: 0

Views: 1018

Answers (2)

Stanislovas Kalašnikovas
Stanislovas Kalašnikovas

Reputation: 9053

You can use TO_DATE(). Try following:

TO_DATE('20121021')

Or

from_unixtime(unix_timestamp('20121021', 'yyyyMMdd'),'yyyy-mm-dd')

Upvotes: 1

Gordon Linoff
Gordon Linoff

Reputation: 1269493

You can also use cast():

select cast(substr(col, 10) as date)

At least, this works for the YYYY-MM-DD format. I should also note that in a date context, a string such as YYYY-MM-DD will typically be converted automatically.

Upvotes: 2

Related Questions