 |
 |
Find a programming school near you
php-db | 2001041
Date: 04/08/01
- Next message: Bob Hall: "Re: [PHP-DB] Re: PostgreSQL versus MySQL"
- Previous message: Jordan Elver: "[PHP-DB] Selecting Dates"
- In reply to: Jordan Elver: "[PHP-DB] Selecting Dates"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
>I'm trying to select records based on dates.
>I have a table with dates in the format 2001-04-08 and I'm using the query:
>
>SELECT name, description, date_time FROM events WHERE YEAR(date_time) = 2001
>AND MONTH(date_time) = 04 AND DAYOFMONTH(date_time) = 08
WHERE field_holding_date="2001-04-08" should work.
Bye,
B.
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe <email protected> For additional commands, e-mail: php-db-help <email protected> To contact the list administrators, e-mail: php-list-admin <email protected>
- Next message: Bob Hall: "Re: [PHP-DB] Re: PostgreSQL versus MySQL"
- Previous message: Jordan Elver: "[PHP-DB] Selecting Dates"
- In reply to: Jordan Elver: "[PHP-DB] Selecting Dates"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
