SQL To JDEdwards Date Conversion

Once Linked JDEdwards database in our MS-SQL database under the Linked server and when we going to see the data it should be encrypted. Here I am show to how to see data like as MS-SQL.

Actual JDEdwards data

My linked server name is “TESTDTA” (JDEdwards database). Open new query window type the below query & press (F5).

Output

JDE1.png

Convert AS SQL Data

Output

 Jde2.png

Meanwhile we can insert the data to JDEdwards and without convention, it’s shouldn’t effect on JDEdwards table. So before insert data convert like a below query.

Output
jde3.png
Thiruppathi Rengasamy
I'm a Dotnet Developer & Blogger. And also I'm working as a senior software engineer. I would like to spend my precious time writing articles, research on .Net technologies, and learning new technologies.