Re: [GENERAL] date_trunc to aggregate values?

2013-02-04 Thread Jason Dusek
2013/2/4 Kirk Wythers wythe...@umn.edu: I am looking for suggestions on aggregation techniques using a timestamp column. In my case I have tried: date_trunc('hour', derived_tsoil_fifteen_min_stacked.time2), but date_truck only seems to aggregate the timestamp. I thought I could use

Re: [GENERAL] date_trunc to aggregate values?

2013-02-04 Thread Kirk Wythers
On Feb 4, 2013, at 3:26 PM, Jason Dusek jason.du...@gmail.com wrote: 2013/2/4 Kirk Wythers wythe...@umn.edu: I am looking for suggestions on aggregation techniques using a timestamp column. In my case I have tried: date_trunc('hour', derived_tsoil_fifteen_min_stacked.time2), but