RE: [PHP-WIN] comparing dates with oracle
| From: | Sandeep Murphy | Date: | Mon, 25 Feb 2002 16:37:43 +0000 |
| Subject: | RE: [PHP-WIN] comparing dates with oracle | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-12271@lists.php.net to get a copy of this message | ||
-----Original Message-----
From: Svensson, B.A.T. (HKG) [mailto:B.A.T.Svensson@lumc.nl]
Sent: segunda-feira, 25 de Fevereiro de 2002 16:35
To: php-windows@lists.php.net
Cc: 'Sandeep Murphy'
Subject: RE: [PHP-WIN] comparing dates with oracle
to_char(DOCUMENT.doc_date,'dd/mm/yyyy') --> is for formatting the date and
"doc_date" after it is meant as an alias...
any mistake here???
I just need to obtain a code for a date which lies within the form inputted
date values...
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??