upmt

  1. sbrown

    Upmt or tday conversion sql

    I have come up with a way to convert the jde time stamp in sql. Concat(concat(concat( case when length(qpupmt)=6 and substr(qpupmt,1,2) between '13' and '24' then to_number(substr(qpupmt,1,2))-12 else case when length(qpupmt)=6 and substr(qpupmt,1,2) between '10' and '12' then...
Top