CA Gen read and display DATE field different between languages / platforms

book

Article ID: 211197

calendar_today

Updated On:

Products

CA Gen - Workstation Toolset CA Gen - Run Time Distributed CA Gen

Issue/Introduction

 

 

There is a DATE value stored in the Microsoft SQL Server with "00010101".

It the DATE is read/displayed by Gen in .NET C# environment as "00010101".

However, the DATE is read/displayed in DB2 on mainframe read by Gen Java As "00000000".

Why is there a difference?

 

 

Environment

Release : 8.5

Component : CA Gen Run Time, Distributed

Resolution

The Gen 'DATE' field is implemented as a SQL Server 'DATE' field.  Change it and implement the Gen 'DATE' field as a SQL Server 'DATETIME' field.  If it is switched to the SQL Server datetime data type, then the lowest date that can put in that field is 01/01/1753 which we will displayed in Gen as a blank field.

Scenario's tried, working as expected:

1. IF the date is 01-01-1753  return 00000000
2. IF the date is 01-01-0001  return 01010001   
3. IF the date is Null return 00000000