From: | Bruno Baguette <bruno(dot)baguette(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | How to split timestamps values by 24h slices ? |
Date: | 2009-03-30 00:07:03 |
Message-ID: | 49D00D27.2030409@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello !
I have a table that contains two timestamps (and some other fields that
does not matter here).
the_table
----------
pk_planning_id ==> INT8 (primary key)
timestamp_start ==> (not null timestamp without time zone)
timestamp_stop =+> (not null timestamp without time zone)
I would like to do a SELECT of that table, but by splitting by 24h day :
So, if I have one planning from 2009-03-30 14h50 to 2009-04-01 19h00, I
would like to get three lines in my SELECT result :
123 | 2009-03-30 14h50 | 2009-03-30 24h00
123 | 2009-03-31 00h00 | 2009-03-31 24h00
123 | 2009-04-01 00h00 | 2009-04-01 19h00
I was thinking of doing that by playing with three UNION requests
(beginning date, intermediate(s) date(s) and ending dates.
Am i going in the right way or is there a cleanest (or more elegant) way
to do that ?
Thanks in advance !
Regards,
--
Bruno Baguette
From | Date | Subject | |
---|---|---|---|
Next Message | V S P | 2009-03-30 00:20:40 | [Q] rollback after select? |
Previous Message | V S P | 2009-03-30 00:02:52 | [Q] LOG: failed to commit client_encoding |