[Stackoverflow] [Progress OpenEdge ABL] Progress SQL : Convert Julian Date into datetime

[Pierre . T]

I working for a client who uses PROGRESS database SQL (i didn't knew this kind of database, so it's my first time that i work on it). My problem it's all the dates are in Julian-date, and i want to convert them into datetime. But i haven't found any document or help online that deals with this.

The only document i found it's: Progress KB - How to Obtain a Julian Date in Progress?

But i want to do exactly the opposite. For example in postgresql:

select to_timestamp(column1::text,'J')
from table1

But on PROGRESS it's harder and there is less information and examples than the others databases on the web

Thank you in advance for your help

Continue reading...