Am facing an issue related to Time.
Am logging shift timing using update query to SQL table. The same vale am show cased in Table. I found time difference between both is showing 9 minutes something. Checked time zone and everything all are ok only.
Is the database updated from the table you're showing us, or the other way around ?
How are things updated/retrieved ?
A 9 minutes difference in ONE field is frankly weird. We need more details.
A few troubleshooting questions:
• What is the datatype of the SQL columns?
• How is the table being populated; is it a binding or a script? Can we see it?
• Is the column's render property set to date or something else?
Table updated from time pick input.
Using runnamedquery data is updated to SQL.
Using query binding data is retrieved from SQL
SQL Column data type is Time(7),
Table populated by query binding only
Property set to time only
What does this look like in your data property?
Are you doing any kind of formatting or transformation in your query?
There is no formatting or transformation is added. Time pick input value directly move to SQL query to insert the time.
In data showing like this
Changed SQL column datatype to datetime from Time(7). Now its working fine. But in SQL table date and time both are showing. From that I show cased only Time in table.
