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
