Re: [datetime SELECT on DB] datetime questino
| From: | Jake Malone | Date: | Tue, 22 Apr 2003 17:13:52 +0000 |
| Subject: | Re: [datetime SELECT on DB] datetime questino | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-27264@lists.php.net to get a copy of this message | ||
Hi Ben,
This may not be the most orthodox way of doing, but I remember it worked for
me on a project I had to a while ago.
Try this:
SELECT * FROM yourtable WHERE dateTimeField LIKE '2003-04-22%'
Hope that helps.
-Jake
"Ben9000" <ben9000@gmx.net> wrote in message
news:200304221801.11691.ben9000@gmx.net...
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hello dear list,
>
> I have a column of type datetime in my DB. This means a date AND the
> time r stored.
>
> I want to search only for a date "2003-04-23" how can I build SELECT
> query which finds all entries with the right date (and leaving out
> the time)?
>
> Somehow I m stuck in this, well I guess its easy - as always - and
> simple - as always - but right now It seems I ve to SELECT all
> entries and filter the strings in PHP :(
>
> Thx for ur help!
> Enjoy the day.
>
> Ben :)
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.2.1 (GNU/Linux)
>
> iD8DBQE+pWdGROwluvOuI4ARAoNpAJ9TaShZEanq+SO8XWeu+YbG+4HqnACePtZ/
> S7KzO298rDP3pCxSyL2UA2E=
> =FYLS
> -----END PGP SIGNATURE-----
>
>