note 10499 added to odbc_exec

From: 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

« previous php.notes (#9459) next »