Posted: Tue Jul 31, 2018 12:11 pm
Late to this thread, not sure if this will help, but we successfully use the following in an ODBC Connector stage to select from MSSql:
Single quotes around the parameters is, as I recall, the first requirement. After that, you have to balance the text parsing that DS does at runtime with the syntax requirements of your DBMS.
Code: Select all
CALLS.local_start_time >= {ts '#CALL_START_DATE_1# 00:00:00.000'} AND
CALLS.local_end_time<= {ts '#CALL_END_DATE_1# 23:59:59.000'}