TDM Portail - F&R shows timestamp rather than a date for a Oracle date field

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

On the Find&Reserve component of the portal, when the table contains a date field (the F&R Model indicates that the field is of type date), the data provided by the Catalog presents the right data but in timestamp format rather than date format (i.e. adds the time 00:00:00 to all dates). We have to manually remove the time added to the date.

When the field is of type date, F&R should not treat it as a timestamp.

Test with CATDM version 4.9.401 (our portal 4355).

Re-tested on CATDM version 4.9.405 (our portal 367). 

 

Environment

Release : 4.9.1

Component : Web Portal - Find & Reserve

Resolution

This is working as expected,  as per the Oracle documentation,   DATE datatype contains the time for Oracle databases. That's why Portal shows DATE columns, including the time fields.

Some quotes from the Oracle documentation: "Oracle DATE columns always contain fields for both date and time." "The DATE datatype stores date and time information. For each DATE value, Oracle stores the following information: century, year, month, date, hour, minute, and second."