How does the NSAW server store date time as compared to NetSuite? NetSuite shows time in the timezone of the user. Does NSAW store date time in the timezone of the user?

AI generated answer (using internal Slack threads):

Based on the conversations provided, it appears that NetSuite and NSAW (NetSuite Analytics Warehouse) handle date and time differently. NetSuite displays date and time based on the user's timezone preference set in the UI. This means that the same date and time can be represented differently for users in different timezones. For example, a date of 2022-04-18 for a user in GMT is represented as 2022-04-18T000000.000+00:00, while for a user in Pacific Time, it is represented as 2022-04-18T000000.000-07:00. These are different date times, but that's how NetSuite treats dates. NetSuite also observes daylight saving time. For instance, the timezone (GMT) Greenwich Mean Time: Dublin, Edinburgh, Lisbon, London in NetSuite is actually Europe/London, which observes daylight saving time. So, a date of 2022-04-18 for Europe/London is represented as 2022-04-18T000000.000+01:00. On the other hand, NSAW is a separate portal that syncs data from NetSuite into its own tables. The conversations do not provide specific information on how NSAW handles date and time. However, since NSAW syncs data from NetSuite, it is likely that it stores date and time in the same format as NetSuite. Please note that this information is based on the provided conversations and may not cover all aspects of date and time handling in NetSuite and NSAW. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******