roncansan New Member Dec 9, 2008 #1 I'm using progress 91D and the odbc driver from OpenLink 3.2. I want to make the following sql statement select mb-num from pro1.mb where logindate='30-NOV-08' but it gives me an error What is the correct way to make this statement Thanks
I'm using progress 91D and the odbc driver from OpenLink 3.2. I want to make the following sql statement select mb-num from pro1.mb where logindate='30-NOV-08' but it gives me an error What is the correct way to make this statement Thanks
roncansan New Member Dec 9, 2008 #2 select mb-num from pro1.mb where logindate='30-NOV-08' will be like select mb-num from pro1.mb where logindate={ d 1980/5/19 }
select mb-num from pro1.mb where logindate='30-NOV-08' will be like select mb-num from pro1.mb where logindate={ d 1980/5/19 }
E ERPgal Member Dec 10, 2008 #3 or ... and jh.duedate between to_date('10/28/2008') and to_date('11/19/2008')