This is my Technical area of troubleshooting and learning new Programming skills and many more. Here you will find answers for many new technologies like asp.net 2.0/3.5,4.0 C# access, mysql, Amazon Webservice ,Sql-server, JD Edwards, SAS, Salesforce, APIs, MVC and many more. please visit & discuss.
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