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

Reply via email to