comparing dates with oracle
| From: | Sandeep Murphy | Date: | Mon, 25 Feb 2002 16:06:04 +0000 |
| Subject: | comparing dates with oracle | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-12269@lists.php.net to get a copy of this message | ||
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";
SQL += " doc_date BETWEEN '15/11/1258' AND '15/08/1988 '";
can anyone pl tell me whats wrong up here??
TIA,
sands