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.
Tuesday, June 28, 2016
Oracle SQL Convert systemdate to JD Edwards Julian
select
to_number(concat('1',to_char(sysdate,'YYDDD')))
from dual ;
No comments:
Post a Comment