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

Reply via email to