How to include datetime in a groovy sql query
I am new to groovy scripting, I am attempting to run this simple query, that will return a count which is then used in a compare. The query is below: row = sql.firstRow('SELECT count(*) FROM...
- Please see if below link helps:
http://stackoverflow.com/questions/30555790/oracle-sql-date-greater-than-statement I modified the SQL query to do the following:
CONVERT(VARCHAR(23),(DATEADD(month, -2, GETDATE())), 121) instead of actual date value.
