date problem
| From: | andy | Date: | Thu, 06 Jun 2002 06:03:50 +0000 |
| Subject: | date problem | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-19635@lists.php.net to get a copy of this message | ||
Hi there,
I would like to count the users out of a mysql db who registered after a
certain date.
The column I have in the db is a char and I do not want to change this
anymore.
This is how a typical entry looks like: May 29, 2002
This is how I tryed it:
// while '10...' is unix timestamp june 1, 02
SELECT COUNT(*) AS c
FROM users_table
WHERE UNIX_TIMESTAMP( user_regdate ) > '1022882400'
Thanx for any help on that,
andy
query