Does anybody have a query to decode the EXEC.EX_DATE column in the DataFlux repository? It kinda looks like a Unix date integer, but it is in decimal format so I am not sure how to decode it.
took me half a day to find out, but here is the result:
attrib new_date format=datetime20.;
new_date = intnx('dtyear',ex_date*3600*24,-60,'S');