Article - CS340045
Prevent ThingWorx Platform from automatically converting timestamps to user's local browser time when executing services
Modified: 02-May-2025
Applies To
- ThingWorx Platform 8.3 to 9.7
Description
- Date mismatch between date column in the database and date viewed in ThingWorx Mashup
- ThingWorx Platform is automatically converting input parameters into UTC before querying the database
- Prevent ThingWorx Platform from converting inputs to UTC before querying the database
- ThingWorx Platform automatically converts date or datetime values to the user's local timezone
- Stop ThingWorx from incorrectly converting date or datetime values received in a database query
- ThingWorx widgets show wrong date when populated with dates from a custom database
- Mashup is not showing the correct data when inputting a date into a Date Picker Widget or Date Time Picker Widget
- Date picker widget is configured with the date only option checked and selected date appears as one day earlier than the actual selected date
- How to convert the date stored in the database in DATE format to DATETIME format in ThingWorx
- When querying dates through a Database Thing from ThingWorx and displaying them in Advanced Grid or DateTime picker, there is date mismatch between the database and Mashup
- Queries concerning DATE or DATE/TIME fields are returning erroneous data
- Date and time stamps on entities and Database do not seem to be showing correct values
This is a printer-friendly version of Article 340045 and may be out of date. For the latest version click CS340045