lt;[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: 30 January 2002 17:05
Subject: [PHP-DB] Re: Date operations.
> Gary,
>
> You have a right to be confused - this problem is short but it is about as
> complex as they get. Still I have a solution for you, also short
Gary,
You have a right to be confused - this problem is short but it is about as
complex as they get. Still I have a solution for you, also short and you'll
(hopefully) find it elegant. I found it interesting...
The thing is we will create a Cartesian product on purpose - this is
something the
The traditional Data Warehouse way to solve this is to have a second table
of dates. The table might look like:
DateTable
---
dayID int,
myDate datetime
And you add all the particular columns that you might ever want to search
on, like:
month int,
year int,
da
