DateTime

This option - reserved for SQL DATETIME or DATE columns - let you define to use or not the DATE col. and the TIME col. when in your Destination table you have a GROUP defined (TPS & SQL)

You check or not the "Use Date" and or "Use Time"

You can also check the "Use TODAY()" and or "Use CLOCK()" so as to fill in default values with the result of these functions

You otherwise select from the respective drop down boxes the DATE or LONG Columns in the Source Table to be used (as other Formats are incompatible)

When in 'ODBC' destination DB, the tool will automatically prohibit you from using the DATE and TIME columns found.

When in any other DB destination types, the tool will warn you to be careful of what you do with these mappings

Depending on the destination driver the TIME checkbox and details will or not be available (Oracle -FireBird and PostGre SQL do not allow DATETIME columns)

DATETIME groups and "Link by Name" process :

You can use the "Link by Name" button even when you have DATETIME columns in GROUPS. DMC will automatically - depending on the destination type of transfer - map or not the DATE and TIME columns, never the GROUP columns and the STRING columns will be filled when in ODBC accordingly with source DATE and TIME columns

To see what are the DATETIME columns we have provided a visual indicator in different icons of a calendar or a clock or a 30 calendar day in both panels

This screenshot is BEFORE any mapping is done

As you can see in this example of TPS -> SQL transfer all GROUP columns are grayed out and have a forbidden icon on them - all DATE columns have a calendar 30 days icon - all TIME columns have a clock icon and the STRING column has another type of calendar icon.

Now after using the "Link by Name" button this will show the same columns NOT being mapped (in ODBC a DATE and a TIME column do not exist in a DATETIME column) :

But the STRING column (containing the real DATETIME) is mapped as a DATETIME also for DMC :

And this is the detail of the STRING mapping done automatically by DMC :

As you can see the DATETIME is checked and BOTH Use Date and Use Time are also checked, plus both Source columns are pre filled for you.

Double-click on those columns and see or set the mappings as this is defined (with or without the TIME part depending on your needs)

If you are doing a to NON ODBC transfer then the process will be different : The STRING column will be mapped normally but both the DATE and TIME columns will have the same DateTime mappings individually

This technique enables you to do your data Transfer in most cases directly without bothering about your DATETIME GROUPS (still as all cases are maybe not covered, do take a look before transferring the data to check it corresponds to your needs)