DateTime Considerations

[iloveitaly]

• NS uses datetime (with 1970/01/01 as the date) for time stores
• NS stores all datetimes with a PST (-08:00) timestamp
• In the use cases that I've come across, the best approach is:
  • the local time set on the rails object should be converted to PST to prevent NS from shifting the timezone information
  • when pulling timezone information from NS, the timezone offset should be set to the rails timezone but the time should be modified based on the NS instance timezone. For instance, if the date in NS is 04:00, the NS company + user timezone is -06:00, and the rails application timezone is -05:00, the final time should be 06:00-05:00

Unresolved items:

• does NS have a datetime data store that displays both date + time in the GUI?
• do any special conversions need to be done for DST?