By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,930 Members | 1,487 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,930 IT Pros & Developers. It's quick & easy.

group by to_char(datetimevar,'mm/dd/rrrrhh24')

P: 1
I have a query that selects and groups by

select to_char(begin, 'mm/dd/rrrr hh24') "STAT HOUR",
document,
avg(stat_hour) 'Mean',
etc.

group by to_char(begin, 'mm/dd/rrrr hh24') "STAT HOUR",
document

This gives me my stats by the hour. However I want to see them by different increments, say every 30 minutes.

Any help would be appreciated.

Thanks.

Jay
Apr 28 '06 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.