Importing date/time values

Considerations when importing data containing date/time values.

  • The field containing the date/time value should be a Date/Time type field in the target table.
  • The user performing the import should have their timezone (in the Time zone [time_zone] field in the User [sys_user] record for that user) set to match the timezone of the date/time values in the import file.
    To set the user timezone, do the following.
    1. Click the user drop-down in the banner and select Profile.
    2. Change the Time zone field value to the timezone of the date/time values in the import file and click Update.