Re: DB Date check !!
| From: | elias | Date: | Tue, 31 Jul 2001 11:51:07 +0000 |
| Subject: | Re: DB Date check !! | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-8589@lists.php.net to get a copy of this message | ||
SELECT * FROM table1
WHERE YEAR(datefield1) = 1999
check datetime functions @ http://www.mysql.com/documentation
"Andrew.Martin" <Martin.Andrew@kpmg-ct.com> wrote in message
news:94DEB1183C2ED4119E240090274D60FA83185F@exchange_dh.kpmg-ms.com...
> Hi,
>
> I want to check the date of numerous records in many DB tables, I have
tried
> using the
> date (Ymd); function but it doesn't appear to work, not sure whats going
> wrong.
>
> I set a variable based on this function and use this variable within the
> select statement!
> Anyone know whats happening or if there is a descent solution available?
>
> thanks,
>
> Andrew
>