[datetime SELECT on DB] datetime questino
| From: | Ben9000 | Date: | Tue, 22 Apr 2003 16:01:10 +0000 |
| Subject: | [datetime SELECT on DB] datetime questino | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-27260@lists.php.net to get a copy of this message | ||
-----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-----