I have a SQL query(in an input tool) that requires a date time field to be updated in the WHERE statement.
If it were just the date I'd have no problem using the Date interface tool to update it, but not when there is a time stamp. There is no actual time, just zeros, but thery're required in order to have the query run.
For example, the line in the query to be updated is: PROD_USIG_STND_VW.AGMT_VAL_CMN_VW.AGMT_VAL_AS_OF_DT = '2019-11-25 00.00.00.000000'
When I run it I get no results back (I do if I manually change the query).
Is there a way to use an action tool to change the date?
Hi I am experiencing a very similar problem but little strange, Below is a screenshot of my workflow, I have connected to HANA view using a SQL script. but when i tried to use "Replace" its not getting replaced and its not giving out any error too. This is strange.
Thank you for suggesting the replace formula. worked like a charm. For those who are struggling, I have a query going against Big Query ODBC and needed to be able to specify the start and end dates and a few other dates. This is just fantastic.