note 10499 added to odbc_exec
| From: | akchu at at ualberta dot ca | Date: | Mon, 08 Jan 2001 01:41:03 +0000 |
| Subject: | note 10499 added to odbc_exec | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-9459@lists.php.net to get a copy of this message | ||
ODBC/MS Access Date Fields:
Matching dates in SELECT statements for MS Access requires the following format:
#Y-m-d H:i:s#
for example:
SELECT * FROM TableName WHERE Birthdate = #2001-01-07 00:00:00#
or
SELECT * FROM TableName WHERE Birthdate BETWEEN #2000-01-07 00:00:00# AND #2001-01-07 00:00:00#
This took me forever to figure out.
http://www.php.net/manual/function.odbc-exec.php