I am trying to convert the number seconds to a time format HH:MM:SS in BOXIR2 from an Informix Database. This is a UNIX timestamp. It is easy enough to export to Excel and do the format/conversion… but is tehre actually something I can do in BOXIR2?
was able to do with Oracle using to_date and then dividing the number by 86400 and adding with start date. but don’t know the informix equivalent. if someone has done similar thing can you please let me know.