Develop an Oracle SQL query in Toad that categorizes dates as 'Current Month', 'Next Month', or 'Third Month' with year changes in mind

Data and Databases
1

Seeking an SQL solution in Toad for Oracle to label dates into month groups considering yearly transitions. Example:

SELECT order_date,
       CASE
         WHEN TRUNC(order_date, 'MM') = TRUNC(SYSDATE, 'MM') THEN 'Current Month'
         WHEN TRUNC(order_date, 'MM') = TRUNC(ADD_MONTHS(SYSDATE, 1), 'MM') THEN 'Next Month'
         WHEN TRUNC(order_date, 'MM') = TRUNC(ADD_MONTHS(SYSDATE, 2), 'MM') THEN 'Third Month'
         ELSE 'Other'
       END AS date_category
FROM Orders;
2

hey, i luv how this query handles monthly casing. its neat using added month methods to deal with year shifts. anyone ever modified it further to work for uneven date ranges? curious if it keeps up wit leap yrs and other oddities.