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
Here is an example of what I mean: Can't upload some values to MSSQL - #15 by Steve-Mcl