Dear Expert I'm using Node ned to connect SQL server. The connection was OK. I want to insert timestamp from node red into SQL, but timestamp is stored in sql with number format. How can I convert it into datTime format in order to storing in sql. Best

Timestamp to SQL Server in Node Red

Steve-Mcl 6 October 2023 05:47 3

Getting the correct format for transmitting a timestamp to SQL server from JavaScript can be tricky.

The least difficult (and safest) way is to use parameters and specify the correct type.

This is all done graphically in the editor if you are using node-red- contrib-mssql-plus

Topic		Replies	Views
How to create a timestamp in the right format for a dashboard chart General node-red-dashboard , function-node	12	7574	1 February 2022
Date formatting Dashboard	15	2022	17 December 2020
Node-RED dashboard chart node with timestamp Dashboard node-red-dashboard , database	3	715	28 February 2022
Sql query of Datetime column returning UTC time not the table data General	11	264	9 December 2022
UI-Table timestamp with correct TZ Dashboard	5	728	28 February 2021