Passing Date value to Oracle SQL
I have a frustrating problem. I want to write a script to use a JMP date code, to query an Oracle database.For instance:StDt = today() - in weeks(4);.If I manually do it using Query Builder, I get something like the code below. What syntax do I need to replace the integer date code with to do this? The documentation is pretty sparse on this topic. Query1 = New SQL Query(
Version( 130 ),
Connection...