AS400 DB2 Query To Group Date By Year, Month and Day
I have a table on an AS400 that has a date field (ORDDATE) in the following format: YYYYMMDD. I wish to run a SQL query (or queries) that groups the the date field by Year, Month and Day. There can be a separate query for each. Thank you.