# Understand UI time input data format

**URL:** https://discourse.nodered.org/t/understand-ui-time-input-data-format/10624
**Category:** General
**Created:** [28 April 2019 20:00 UTC](https://discourse.nodered.org/t/understand-ui-time-input-data-format/10624 "2019-04-28T20:00:52Z")
**Posts on this page:** 1
**Showing post:** 19

<div class="post-metadata">

### Author: ![azan5050](https://avatars.discourse-cdn.com/v4/letter/a/bc79bd/32.png) [@azan5050](https://discourse.nodered.org/u/azan5050)
#### Post date: [26 September 2025 11:44 UTC](https://discourse.nodered.org/t/understand-ui-time-input-data-format/10624/19 "2025-09-26T11:44:15Z")

</div>

> [@Datetime formating issue](https://discourse.nodered.org/t/datetime-formating-issue/99169):
>
> 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

---

_[View the full topic](https://discourse.nodered.org/t/understand-ui-time-input-data-format/10624)._