Can anyone point me to the answer? I want to use an arbitrary group in the group by statement. I can group by year but want to change the calendar year to another unit of measure such as quarter.
This works: select to_char(actual_date,'YYYY'), sum(value) from daily_data where sensor_id=? group by to_char(actual_date,'YYYY') Any ideas? -------------------------------------------------------- Anna Q. Fong, Webmaster California Data Exchange Center
