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

Related Posts

  • 44
    SQL Operations Studio is a data management tool that enables you to work with SQL Server, Azure SQL DB and SQL DW from Windows, macOS…
    Tags: sql, open, data, server
  • 37
    Introduction In this article, we will learn about Amazon web service with MS-SQL database using local ms-sql management studio. Requirements Register AWS console SQL Server…
    Tags: sql, server, database, select, ms-sql
  • 35
    Do you want to know how creates any application in windows application with SQL Server and using CURD operation?. This blog for you. Here I…
    Tags: select, sql
  • 31
    Hi Everyone, My name is Thiruppathi Rengasamy. I 'm a .Net Developer, Author & Blogger. And also I'm working as senior software engineer in Microsoft Technologies…
    Tags: server, sql
  • 29
    In this blog, I will demonstrate how to convert string into table list the dynamically using MS-SQL user define function. Create a function: When we…
    Tags: server, table, ms-sql, select, convert
Show Buttons
Hide Buttons