Time comparison
| From: | Lynn Siprelle | Date: | Sun, 31 Dec 2000 04:36:51 +0000 |
| Subject: | Time comparison | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-5538@lists.php.net to get a copy of this message | ||
Hi guys--
Sorry to bother you with what is probably a simple question. I've read through the manual and
I'm still not sure of what I'm doing; I'm getting caught in strings vs. numbers, ie,
I'm afraid that what I'm trying to do won't work because I'm dealing with
strings instead of numbers.
I'm trying to pull rows out of a MySQL table where the date stamp looks like:
2000-12-30 19:22:00
I want to pull all rows that have been placed in the db in the last 24 hours. How can I compare the
current date/time to the date stamps in the table?
Thanks,
Lynn
--
Lynn Siprelle, Siprelle & Associates: Web Construction and Publishing
Chief Assoc. Josephine b. 9/9/97 * New Assoc. Louisa due 5/1/01
Business: lynn@siprelle com | Personal: lynsa@siprelle.com
The New Homemaker: http://www.newhomemaker.com/