I keep forgetting how to do this.
How to group on a date column (date_col in the example) in Oracle:
SELECT count(*) FROM table GROUP ON TO_CHAR(date_col, 'DD-MON-YYYY HH:MI:SS')
For other format strings than
see this page.
You must be logged in to post a comment.
This site uses Akismet to reduce spam. Learn how your comment data is processed.