Hive cast string to date dd-MM-yyyy

string date casting hive
pele88 picture pele88 · Sep 9, 2015 · Viewed 163.4k times · Source

How can I cast a string in the format 'dd-MM-yyyy' to a date type also in the format 'dd-MM-yyyy' in Hive?

Something along the lines of:

CAST('12-03-2010' as date 'dd-mm-yyyy')

Answer

Ardit picture Ardit · Sep 9, 2015

try:

from_unixtime(unix_timestamp('12-03-2010' , 'dd-MM-yyyy'))

Related questions

Android, How can I Convert String to Date?

I store current time in database each time application starts by user. Calendar c = Calendar.getInstance(); String str = c.getTime().toString(); Log.i("Current time", str); In database side, I store current time as string (as you see in above …

Read More
Java string to date conversion

What is the best way to convert a String in the format 'January 2, 2010' to a Date in Java? Ultimately, I want to break out the month, the day, and the year as integers so that I can use Date …

Read More
Change date format in a Java string

I've a String representing a date. String date_s = "2011-01-18 00:00:00.0"; I'd like to convert it to a Date and output it in YYYY-MM-DD format. 2011-01-18 How can I achieve this? Okay, based on the answers I retrieved below, …

Read More