| Time | Entry |
|---|---|
| 8:0 | |
| 9:0 | Meeting with sales team |
| 10:0 | |
| 11:0 | Conference call with Widget Inc. |
| 12:0 | |
| 13:0 | |
| 14:0 | |
| 15:0 | Presentation to board of directors |
| 16:0 | |
| 17:0 | |
| 18:0 |
The query to fetch this data, with help from PEAR::Calendar, might be;
SELECT
*
FROM
diary
WHERE
eventtime >= '1066921200'
AND
eventtime < '1067007600';