dropping partitions using date function

[LKBrwn_DBA]

Try this:

SELECT partition_name
  FROM user_tab_partitions
 WHERE table_name = 'XXX'
       AND partition_name < 'P_' || TO_CHAR ( (SYSDATE - 30), 'YYYY_MM_DD');