Tuesday, 9 July 2013

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
Example query with Groupdate functions
Groupdate.sql project page