Date comparison problem
| From: | Gabor Niederlaender | Date: | Wed, 10 Jul 2002 14:20:45 +0000 |
| Subject: | Date comparison problem | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-20454@lists.php.net to get a copy of this message | ||
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