Subject | RE: [firebird-support] Groupby on date |
---|---|
Author | Chad Z. Hower |
Post date | 2004-11-09T19:07:26Z |
:: Is the table growing and growing and you still want to group
:: by month, not depending on what year it is?
Actually yes year would be part of it.
:: SELECT
:: EXTRACT(MONTH FROM FieldTimeStamp),
This was exactly my plan and how Im doing it now. But will Extract use an
index? Also I might need to group by year and month in some cases where the
criteria might extend beyond 12 months.
:: by month, not depending on what year it is?
Actually yes year would be part of it.
:: SELECT
:: EXTRACT(MONTH FROM FieldTimeStamp),
This was exactly my plan and how Im doing it now. But will Extract use an
index? Also I might need to group by year and month in some cases where the
criteria might extend beyond 12 months.