Configuring Date and Datetime Formatting

Each RDBMS handles date and datetime field data in different ways. You can instruct Mass Change to automatically format your date and datetime fields correctly using the Mass Change Datetime Parms page.

To specify the datetime formatting for an RDBMS:

  1. Select Use, Mass Change Datetime Parms.

    The Mass Change Datetime Parms dialog appears.

  2. Select a Database Platform and click OK.

    The Mass Change Datetime Parms page is displayed.

  3. Specify the appropriate prefixes and suffixes.

  4. Click the Save button to save your work.