passing to_date function in DAO for oracle DB
C / C++ / MFC
1
Posts
1
Posters
0
Views
1
Watching
-
Dear all;), I have being using DAO to connect to oracle 8i DB, but I try to pass a sqlstatememet = "select * from table where datefield = to_date ('2002-01-23','yyyy-mm-dd')" in the code CDaodatabase database; CDaoRecordset recset(&database); recset.Open(AFX_DAO_USE-DEFAULT, sqlstatememet); I always get this problem error message "Undefined function 'to_date' in expression" Anyone pls help!!!!:wtf: