Understand UI time input data format

[azan5050]

Datetime formating issue

Create a dashboard with two datetime inputs. Convert these UTC times to the server's local time and format them for SQL Server's smalldatetime type. Then, query the database for records within that range and send the results to a chart. 26/09/2025, 16:22:54node: debug 15 sensor_data_query : msg.payload : Object object query: string SELECT [Id], [SensorName], [SensorValue], [Alert], [Timestamp] FROM [IndustrialDB].[dbo].[SensorData] WHERE [Timestamp] BETWEEN ? AND ? …

kindly reply here