From: Sandeep Murphy
Sent: Monday, February 25, 2002 5:06 PM
>Hi,
>
>I am trying to compare dates between my form fields and my db field but so
>far keep getting a format error.. Am using an Oracle Db...
>
>my query reads like this:
>
>SQL = "SELECT DISTINCT to_char(DOCUMENT.doc_date,'dd/mm/yyyy')
>doc_date,DOCUMENT.document_code from Document where";
Did you miss a comma between to_char(DOCUMENT.doc_date,'dd/mm/yyyy') and
doc_date ?
>SQL += " doc_date BETWEEN '15/11/1258' AND '15/08/1988 '";
>
>can anyone pl tell me whats wrong up here??
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
