Re: calculating 28 days from db date posted col
| From: | Jason Wong | Date: | Wed, 07 Aug 2002 10:51:39 +0000 |
| Subject: | Re: calculating 28 days from db date posted col | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-21041@lists.php.net to get a copy of this message | ||
On Wednesday 07 August 2002 18:37, Dave Carrera wrote:
> Hi All
>
> I have a col that uses date time stamp in UNIX format i.e.: 2002-08-04
> 16:36:51
These are NOT UNIX timestamps.
> How can I say that there has been X activity for the moth 08 (using the
> date sample above)
Try:
SELECT * FROM table where MONTH(date_column) = 8
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
/*
Communist revolutionaries taking over the server room and demanding all the
computers in the building or they shoot the sysadmin. Poor misguided fools.
*/