Obtain date from timestamp

Question

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.

did you happen to try my solution? If it worked then please accept the answer and vote up! — JRG, Jul 30 '17 at 07:35

score 13 · Accepted Answer · answered Jul 25 '17 at 00:24

13

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

answered Jul 25 '17 at 00:24

JRG

4,037
3
23
34

5

Input to TO_DATE can be also a Timestamp. – Erik Barajas Jul 04 '18 at 17:55

Obtain date from timestamp

1 Answers1

Linked