Groupdate.sql - Better SQL group by date

Groupdate.sql provides the simplest way to group by:

• day
• week
• month
• day of the week
• hour of the day
• and more

Timezone support is included and you can use Groupdate functions with any programming language. Supported SQL DBMS: MySQL and PostgreSQL.

Groupdate.sql creates SQL functions, which are stored by the database. You can use these functions with any ORM (or without one).

Example query with Groupdate functions

Groupdate.sql project page