Board index » delphi » SQL Query (Group by Month)

SQL Query (Group by Month)

When running a query I want to group my results by month using date field.

Thank you
Pavels Ruhmans

 

Re:SQL Query (Group by Month)


Quote
>When running a query I want to group my results by month using date field.

You can't do this with local SQL.  You can only group on regular
fields

--
Brian Bushay (TeamB)
Bbus...@DataGuidance.com

Re:SQL Query (Group by Month)


Select ...., EXTRACT(MONTH from <datefield>) as mymonth ....
group by mymonth

Nick Spurrier (MoDESoft, UK)

Other Threads