A company needs to integrate data from multiple time zones. How should the data transformation logic be designed to standardize the time data?

  • Assign a common time zone to all timestamps
  • Convert all timestamps to UTC before processing
  • Ignore time zones and process data as-is
  • Use local time for all timestamps
To standardize time data from multiple time zones, it's recommended to convert all timestamps to Coordinated Universal Time (UTC) before processing. This ensures consistency and avoids complications arising from different time zones.
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *