Hi, Assuming your dates have the format you specified and that you only want to compare dates, not time aswell.
$str_sql = "SELECT something FROM mytable WHERE LEFT(my_datetime, 10) = '" . str_replace("/", " ", $form_date) . "'"; or if day / month is reversed in MSSQL $str_sql = "SELECT something FROM mytable WHERE LEFT(my_datetime, 10) = '" . substr($form_date, 3, 2) . " " . substr($form_date, 0, 2) . " " . substr($form_date, 6, 4) . "'"; Regards Joakim Andersson > -----Original Message----- > From: Gabor Niederlaender [mailto:[EMAIL PROTECTED]] > Sent: Thursday, July 11, 2002 8:36 AM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: RE: [PHP-DB] Date comparison problem > > > But I would like to do it the other way round. I mean for the solution > you have mentioned, I have to make the query on the whole record, then > compare the two dates and filter the right ones. I'd like to make the > query look like: > > SELECT something FROM table WHERE datetime < "$form_date" > > So I think I have to adjust the form of my "$form_date". > > Or am I making a mistake somewhere? > > Thanx > Gabor > > ------------------- > > This is how I do it: > > > > date("m/d/Y",strtotime(odbc_result($rs,"ts"))) > > > > where $rs is the result set and "ts" is the name of the field > containing the datetime. > > > > <>< Ryan > > > > -----Original Message----- > > From: Gabor Niederlaender [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, July 10, 2002 8:21 AM > > To: [EMAIL PROTECTED] > > Subject: [PHP-DB] Date comparison problem > > > > > > Hi all! > > > > I have got a "datetime" field in a MS-SQL DB, and I have a "date > > field" in my html-form with the format: DD/MM/YYYY. > > > > I would like to compare the two, but I think the two formats are a > bit > > different and they do not really want to be compared:) > > > > If I write a query to write out the "datetime" field from the DB, I > > get the form : > > > > 02 05 2002 12:25 > > > > In the HTML-form it looks a bit different: 12/10/2000 > > > > I do not really want to explode the form-data and than build a new > > timestamp, it has to be a more simple way. > > > > Thanks, best regards > > > > Gabor > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php