What is the correct way to provide “formats” with date functions when doing masking with FDM or TDM Portal?

book

Article ID: 205718

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

One of my questions is:
What is the correct way to provide “formats” with date functions?
The documentation shared with me earlier shows all possible formats in ‘CAPS’ but it mentions GT-DATAMAKER only.
When the AddDays function had issues earlier, a Broadcom engineer had told us to use small caps, with month in CAPS  like dd-MM-yyyy, yyMMdd, etc.
Oracle’s way of describing its default format is dd-MON-yy.


What is the correct format to be used when masking DATETIME fields on a target database.

 

Cause

The supported DATETIME format is controlled by the target database engine itself.
This is not controlled by FDM or TDM Portal.

Environment

FDM 4.9.x
TDM Portal 4.9.X

Component : CA Test Data Manager

Resolution

The supported DATETIME format is controlled by the target database engine itself.
This is not controlled by FDM or TDM Portal.


Oracle has a set of data formats it supports.
An example is below:
Date Format Types (oracle.com)


MS SQL server has another ser of formats it supports.
An example is below:
Format SQL Server Dates with FORMAT Function (mssqltips.com)
date (Transact-SQL)

Here is the DB2 version:
Datetime values

Examples from the TDM documentation:
Function Date Formats (broadcom.com)

For each masking job, you will need to determine the target database type and version and then review the data to be masking and determine the correct format for the field to use.