Skip to main content

Handling EURO date format from SQL server

  • August 2, 2019
  • 0 replies
  • 0 views

All - I'm migrating Mainframe application to Micro Focus Enterprise server environment, Enterprise Developer is our build tool. database on Mainframe is DB2 where are in target infrastructure database is RDS Distribution for SQL Server.

Date fields in DB2 are in EURO format which is "DD.MM.YYYY" , data migrated to SQL server is in YYYY-MM-DD format.  I have changed SQL Server Default Language to "British English". I have compiled my COBOL DB2 application with HCOS Compile directives to avoid Application layer changes (no queries have been changed due to HCOS). When my program fetches data from SQL server it's in yyyy-mm-dd format.

Can I know if some configuration changes are been missed here? Thanks in advance.

 


#EnterpriseDeveloper

0 replies

Be the first to reply!