SQL To JDEdwards Date Conversion1 min read

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

Author Profile

Thiruppathi Rengasamy
I 'm a .Net Developer & Blogger. And also I'm working as senior software engineer in Microsoft Technologies for 5+ Years.I would like to spend my precious time in writing articles, research in .Net technologies and to learn new technologies.

Hits: 40