Convert juilian timestamp to gregorian timestamp

[#1]

Hello!

I have timestamps that are in Julian date system and I now want to convert them to Gregorion time and formatted as "YYYY-MM-DD hh-mm-ss" when I load a table. Below are some examples of the Julian timestamps I have.

2456087,27855

2456089,56585

2456089,56718

2456089,57735

Thanks in advance!

Regards

Mårten

[marcus_sommer]

I think this will be helpful: Non-Gregorian calendars

- Marcus

[ganeshsvm]

Check out the following link, will be helpful for you,

https://community.qlik.com/docs/DOC-17826

Regards,

Ganesh

[swuehl]

http://aa.usno.navy.mil/faq/docs/JD_Formula.php