How to convert Julian date to calendar date on Hive?

Question

Is there any Hive function available to convert from Julian date to calendar date?

There are multiple types of Julian date. The Julian date I have takes 15001 for 2015-01-01.

I couldn't find any relevant information on this page:

score 0 · Answer 1 · answered Aug 17 '15 at 02:39

0

 date_add('2015-01-01', juliadate - 15001)

answered Aug 17 '15 at 02:39

Osiris

score 0 · Answer 2 · edited Dec 01 '15 at 23:57

0

Just wanted to add.

The below is for julian date format yyyyDDD

Input_julian_date : 2006121

substr(from_unixtime(unix_timestamp(cast(cast(Input_julian_date as int) as string),'yyyyDDD')),1,10)

Output : 2006-05-01

edited Dec 01 '15 at 23:57

gre_gor

answered Dec 01 '15 at 23:10

Parul Sharma

score 0 · Answer 3 · answered May 26 '20 at 20:12

Using "yyyyDDD" correctly converts Julian dates in Hive.

For example, I had a string column like "201707299999ABC" where the first 7 digits were the Julian date:

TO_DATE(FROM_UNIXTIME(UNIX_TIMESTAMP(SUBSTRING(my_julian_column, 0, 7), "yyyyDDD")))

Produces 2017-03-13 as expected.

score 0 · Answer 4 · edited Apr 14 '22 at 03:05

0

Julian Date Format -- yyyyDDD The Date Format which is expected -- 'yyyy-MM-dd'

from_unixtime(unix_timestamp(cast(**julianl_date_col** as string),'yyyyDDD'),'yyyy-MM-dd')

edited Apr 14 '22 at 03:05

Hiten004

answered Apr 07 '22 at 14:10

Ankita

4 Answers4