Database Reference
In-Depth Information
Figure 11.19
Selecting dates from a calendar.
Common Date Queries
Date queries can be very complicated to create, and if you are struggling with one, get help!
A brief search on the internet can reveal that someone has already written a query that if
not of immediate use may well put you on the correct path again.
Also, remember the on-line MySQL manual that installed along with MySQL. This con-
tains more examples of common queries which can be very useful. One of note is a method
to calculate ages, which is not reproduced again here, but can be found under the Date and
Time Functions section of the manual (Section 6.3.4 in the MySQL 4.11 alpha manual).
Search WWH ::
Custom Search