cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

CHANGE IN DATE TIME ZONE IN CSV EXPORT

Participant

CHANGE IN DATE TIME ZONE IN CSV EXPORT

I am facing a problem in the Export file . Where the CSV export file generated from the Query property history service using Export Widget gives DATE TIME in UTC , which is 5:30 Hours behind IST.

When visualized in Mashup by using grid, the DATE & TIME is in IST .

Please find the screenshots for reference.

3 REPLIES 3

Re: CHANGE IN DATE TIME ZONE IN CSV EXPORT

All date time is recorded in Thingworx in UTC and then browser side it is converted.

If you need to shift your export time stamp before exporting, you will need to use a service to shift the data according to your time zone.

Re: CHANGE IN DATE TIME ZONE IN CSV EXPORT

Hello PaiChung , 

Can you also please help me with the service or the steps I need to execute for shifting the time. 

 

 

Thanks, 

Anup D

Re: CHANGE IN DATE TIME ZONE IN CSV EXPORT

You will need to know the time shift, either pre-defined or as a parameter.

After that you can retrieve the raw data and use DeriveFields (from Infotable functions) and the Date Time Functions (in Snippets) to shift the timestamp.

This would be the most efficient, but it will require a bit of a 'hack' (separate wrapping service that only needs the timestamp and has hardcoded time shift or based of a property) because you can't feed two parameters to a function called within DeriveFields

The brute force way otherwise would be to loop through the records.