I have an odbc connection from Toad DA to an Oracle Bi server. I am trying to do a simple query : query a table where “Birth Date” > ‘01/16/1957’
In the target BI server, 'Birth Date" is varchar2, and hence it returns values 01/19/1964, 01/24/1935… 01/24/1935 should not be returned.
How can I use a date function to compare like I would normally do :
where to_date(“Birth Date”, ‘mm/dd/yyyy’) > to_date(‘01/16/1957’, ‘mm/dd/yyyy’)
The above results in sql syntax error.
Any help would be appreciated!