Re: CONVERT STRING VARIABLES TO DATES, THEN COMPARE (HOW?)
| From: | Jason Wong | Date: | Fri, 07 Nov 2003 19:30:40 +0000 |
| Subject: | Re: CONVERT STRING VARIABLES TO DATES, THEN COMPARE (HOW?) | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-31494@lists.php.net to get a copy of this message | ||
On Saturday 08 November 2003 03:08, Karen Resplendo wrote:
> Yes, the values echo out the way I expect them. But these are displayed
> values, not dates, I'm pretty sure, and that is why the comparison is
> failing.
>
> The question began very simply. I will try to make it simpler:
>
> How do I compare a string date from a database to today's date using PHP?
The proper way would be to convert both to unix timestamps then a simple
greater-than or equal-to comparison would suffice.
> I can do it with my eyes closed in SQL. I don't want to if I can avoid it.
It's more efficient to do so, so can I ask why you want to avoid it?
--
Jason Wong -> Gremlins Associates -> www.gremlins.biz
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
------------------------------------------
Search the list archives before you post
http://marc.theaimsgroup.com/?l=php-db
------------------------------------------
/*
A truth that's told with bad intent
Beats all the lies you can invent.
-- William Blake
*/