12-27-2013 10:28 AM
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.
03-12-2014 12:50 PM
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');