I am trying to render the following line in the stored procedure written in javascript –
------Expected output------
select val1 from tableName where REGEXP_REPLACE(var1, '@|T|Z|\(GMT-04:00\))',' ')) >= date1
At present the code looks like this in the stored procedure –
----Actual code--------
SELECT val1 from tableName where REGEXP_REPLACE(var1,''@|T|Z|\\\\(GMT-04:00\\\\))'', '' '')) >= date1
The above code does result in the expected output, however I am trying to optimize this solution, and looking for cleaner way to achieve this final result. Any suggestions are appreciated. TIA.