Forum Discussion

donepr's avatar
donepr
New Contributor
8 years ago

Date Timestamp error while trying to use the "sql server update" snap?

Hi All, I’m trying to update the target sql server table using “sql server update” snap with the where condition “INSERTTS = $INSERTTS” (INSERTTS is the insert date timestamp) but I’m getting the ...
alchemiz's avatar
alchemiz
Contributor III
3 years ago
Copy LinkReport

Hello,

I think you might want to add a single quote… e.g.

"INSERTTS = '" + $INSERTTS + "'"

or if the format is the issue...

"INSERTTS = '" +  Date.parse($INSERTTS).toLocaleDateTimeString({"format": "yyyy-MM-dd HH:mm:ss.SSS"}) + "'"

Thanks,
EmEm