06-13-2022 05:35 AM
Hi,
My requirement is to pass the date as a string “YYYY/MM/DD HH:MI:SS” as a parameter to Oracle procedure snap. I amssusing the expression - Date.now().toLocaleDateString({“format”:“yyyy/MM/dd HH:mm:ss”}).toString()
I can see the correct format in the value but while it is passed as a parameter it always has additional characters as below -
Could you please suggest how I can correct this expression?
06-16-2022 11:37 AM
Oracle Procedure snap accepts number type parameter so I have to convert it to integer in this snap. This looks like a product bug to me.
06-19-2022 11:17 PM
You’re using .toLocaleDateString() while passing a DateTime format. Also, you don’t need the .toString() function, the previous one already puts the date into stringified version. Make sure you change that and validate.