convert Timestamp to Date in JSL Scripting

Question

I am trying to run a SQL Statement in JSL, but the statement includes a column with datetime, i do not need datetime but simply date. JSL does not like "cast for some reason" can someone please assist

Open Database(
        "DSN=EDWPROD; UID=" || ID || ";PWD=" || PASS || ";MODE=SHARE;DBALIAS=EDWPROD;",
        "SELECT  distinct Cast(TRXN_TS as date) as Trans_Date
    FROM    pODSCFAView.IMP_DBT_AUTHZN_POST_VW
    where Cast(TRXN_TS as date) as Trans_Date between (current_date - 16 day) and (current_date - 3 day) 
    WITH UR");