Hive: convert date to int

Question

Input looks like:

2017-07-03

Expected output looks like:

20170703

I tried the below code:

year(2017-07-03) * 10000 + month(2017-07-03) * 100 + day(2017-07-03))

Is there any built-in function that can do this conversion?

Thank you

Can you explain why you are doing this? I would expect you to convert it to a long "Unix epoch" — TheFiddlerWins, May 09 '18 at 17:33

score 0 · Answer 1 · answered May 09 '18 at 18:27

0

You can use from_unixtime and unix_timestamp with cast to do this.

select cast(from_unixtime(unix_timestamp('2017-07-03','yyyy-MM-dd'),'yyyyMMdd') as int)

answered May 09 '18 at 18:27

Vamsi Prabhala

score -1 · Answer 2 · answered May 09 '18 at 17:58

-1

You can split on '-', then concatenate back again. Or replace "-" with "".

regexp_replace("2017-07-03", "-", "")

answered May 09 '18 at 17:58

Acccumulation

cast(regexp_replace("2017-07-03", "-", "") as int) – src3369 May 11 '18 at 04:37

2 Answers2