How to convert a Julian date into timestamp in Snowflake

Asked Sep 28 '20 at 05:47

Active Oct 04 '20 at 07:21

Viewed 1,667 times

-1

I have dates like 54940,55001,54970 etc. I need to convert these dates into yyyy-MM-dd format in snowflake

edited Oct 04 '20 at 07:21

Marcel

2,454
1
5
13

asked Sep 28 '20 at 05:47

Neha Nayal

21
4

1

And what's your question about this? What have you tried, where are you stuck? – Nico Haase Sep 28 '20 at 07:33

1 Answers1

-1

The following steps should help:

Convert the julian to a gregorian date with a function (the conversion depends on your understanding of a julian date - there are different ones. If you try to google that, you may find several conversion rules)
Convert the string/integer to a date by using TO_DATE() https://docs.snowflake.com/en/sql-reference/functions/to_date.html

answered Sep 30 '20 at 08:08

Marcel

2,454
1
5
13