Progress/Open Edge database. Getting date and time from a field that is all seconds.
I am new to Progress/Open Edge database. I need to get the date and time from field that is defined as seconds.
Field Value= : start-time = 917872604
start date returns the correct date 2019-02-01
but I need to get the time from that field.. it should equal 12:36:44 when I run it thru a converter program on the web.
SELECT to_date('19900101','yyyymmdd') + "start-time"/86400 as startDate, "start-time"FROM PUB."sfeventcds"
Open in new window