It should be possible on thingworx to show/manage a date-time value without the hour-shift caused by the timezone of the user web-browser.
As you know date time works internally as UTC, but when it is rendered to the browser, the hour is shifted to the timezone of the computer running the web browser. If you change the timezone of the computer, the shown time will change !
We have for example an external SQL with date-time values. if we keep those data on a DATETIME object (using a datashape), when it is shown on the browser the time (hour) will change due to user timezone.
We want instead to show those date-times as they are on SQL.
To do that I have to convert date-time into strings, and so shown as string, but it will limit a lot the functionality.
It could be made may be in two ways.
- adding on the DATETIME formatting option (yyyy MM dd ...), a new tag (NOTZ?)that disables the timezone shift when data is rendered on the browser
- create a new DATETIME_NOTZ variable type that to the same thing
An attention should be made on date-time widgets (date-time picker time-selector etc...), may be those need to have a flag the disabled date-time timezone shift on the "reverse side" (browser to thingworx).
May be a new variable type DATETIME_NOTZ could be a more flexible and system-wide feature. All mashup objects using this variable wont make timezone-shift