fishScript.com Script con annotazioni in italiano e inglese

PostgreSQL

Home >PostgreSQL > Grouping data by the week

Example using function date_trunc with 'week' parameter to group dates, timestamp data.

finance-# select  date_trunc('week',tnx_date) week_start, count(1) tot_tnx 
finance-# from transaction
finance-# group by date_trunc('week',tnx_date)
finance-# order by date_trunc('week',tnx_date) desc
finance-# limit  10
finance-# ;


     week_start      | tot_tnx 
---------------------+---------
 2015-06-01 00:00:00 |    11276
 2015-05-25 00:00:00 |    34113
 2015-05-18 00:00:00 |    33430
 2015-05-11 00:00:00 |    33244
 2015-05-04 00:00:00 |    12980
 2015-04-27 00:00:00 |    39650
 2015-04-20 00:00:00 |    35251
 2015-04-13 00:00:00 |    25171
 2015-04-06 00:00:00 |    17229
 2015-03-30 00:00:00 |    19253
(10 rows)

Warning: include(ads/text468x15.html): failed to open stream: No such file or directory in D:\inetpub\webs\fishscriptcom\documents\view_document.php on line 131

Warning: include(): Failed opening 'ads/text468x15.html' for inclusion (include_path='.;C:\php\pear') in D:\inetpub\webs\fishscriptcom\documents\view_document.php on line 131

Tutorial

PostgreSQL determine database uptime [PostgreSQL]

Postgres check database is Master or Replica ways to check database replication role [PostgreSQL]

Ordering by highest or lowest value of multiple columns PostgreSQL functions in order by clause [PostgreSQL]

Posgresql how disable and renable foreign constraints forcing data into a table ignoring foreign keys (or trigger) [PostgreSQL]
Comandi

date and timestamp simple Using date and timestamp [PostgreSQL]

Add time to a date date function operation [PostgreSQL]

How set a default schema working away in your postgreSQL session [PostgreSQL]

postgres tip: how re-execute a query every n second a nice postgres shell command [PostgreSQL]

Grouping data by the week example date_trunc function, trimming days by the week [PostgreSQL]

How get PosgreSQL table size pg_total_relation_size function [PostgreSQL]

PostgreSQL determine database size pg_database_size function returns database size [PostgreSQL]

PostgreSQL enable autostart at reboot on Centos / Redhat Configure autostart after reboot [PostgreSQL]

Argomenti

PostgreSQL

Cerca