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).



Convert AS SQL Data



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.


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