CODEWITHSUNDEEP
hiveqlhue
Sarah
Sarah

Reputation: 161

Obtain date from timestamp

I have a date field like this: 2017-03-22 11:09:55 (column name: install_date) I have another date field with date like this: 2017-04-20 (column name: test_date)

I would like to obtain only the date field from the above (2017-03-22) so that I can perform a DATEDIFF between install_date and test_date.

Upvotes: 8

Views: 13264

Answers (1)

JRG
JRG

Reputation: 4187

Assuming you are looking for this in Hive, you can use TO_DATE function.

TO_DATE('2000-01-01 10:20:30') returns '2000-01-01'

NOTE: Input to TO_DATE is a string

Upvotes: 13

Related Questions