Hi everyone, need help on converting date to specific format using ODBC. I've tried the following syntax below but neither of them works. Any idea? SELECT TO_DATE(createddate,’YYYYMMDD’) SELECT TO_CHAR(createddate,’YYYYMMDD’) Error: Unsupported scalar function: TO_DATE / TO_CHAR