This is my technical area for troubleshooting and learning new programming skills and much more. Here, you will find answers on a wide range of technologies such as AI, Machine Learning, OpenAI, Databricks, ASP.NET, C#, Python, Microsoft Access, MySQL, Amazon Web Services, SQL Server, PL/SQL, JD Edwards, SAS, Salesforce, APIs, MVC, and many others. Please feel free to visit and join the discussion!
Monday, August 31, 2020
Convert JD Edwards Julian date to calendar date PL SQL
Convert JD Edwards Julian date to calendar date
SELECT TO_CHAR(TO_DATE(Y$CKDT+1900000, 'YYDDD'), 'MM/DD/YYYY') as CheckDate, F1.* FROM PRODDTA.F0719 F1
No comments:
Post a Comment