WriteCSVFile service output EST instead of UTC

[AdarshBNair]

Hi 

I have a service where i write a propertyHistory infotable to a csv file. In the UI, I can see the datetime in IST format, but I expected the timestamp on the written csv file to have UTC format. But instead, the timestamp is in EDT/EST format. Is there a method to change this conversion so that I can get the output timestamp in UTC. Since the EST/EDT vary each year the quality of the exported data has an expiration date. Please let me know your comments. @VladimirRosu 

[VladimirN]

 Hi,

There have been similar questions before:

• "How do I display local time instead of UTC?": https://community.ptc.com/t5/ThingWorx-Developers/How-do-I-display-local-time-instead-of-UTC/td-p/697252
• "How to convert a UTC Date to a local time string?": https://community.ptc.com/t5/ThingWorx-Developers/How-to-convert-a-UTC-Date-to-a-local-time-string/td-p/781399
• "Unable to set time at 00:00:00 hours for other timezone": https://community.ptc.com/t5/ThingWorx-Developers/Unable-to-set-time-at-00-00-00-hours-for-other-timezone/td-p/780798

[AdarshBNair]

Hi I have attached an image of two end results TWX GUI is QueryNamedPropertyHistory output which is in IST, and thats allright The CSV output is what I get when writing the left handside infotable to csv using WriteCSVfile service. I expected the timestamp to be writtten in UTC (5HRS AND 30 MINS BEHIND IST) But it's getting written in EST (9hrs and 30 mins behind). This is the issue I have. I want to write the data in UTC since it does not depend on Daylight saving or such variations. I am convinced that it has something to do with the way CSV Parser is interpreting the timestamp. Please let me know if some modifications to extension could fix this issue or any other solution is available.

[Sathishkumar_C]

In what time zone does the Thingworx server hosted? and Thingworx version?

• Thingworx automatically converts the timestamp to client (browser) time zone.