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.
Thursday, January 5, 2017
Convert JDE Julian date to Calendar date PL/SQL
convert Julian date to Calendar date Oracle
select to_char(to_date(GLDGJ+1900000,'YYYYDDD'), 'MM/DD/YYYY') as adate , gldgj from PRODDTA.F0911 where gldgj>116360
No comments:
Post a Comment