• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

tday

  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