Hi everyone, I currently have the below code but was hoping I could improve this because I currently select 3 different variants, but specify the dates separately for each. Ideally I'd like to only have one date search so I only have to change one set of dates. I've separated off each section in a different colour. I've tried bracketing them differently and having just one date atthe end but can't seem to get it quite right- is anyone able to help please?
Code:
select TICKET_ID_ "Ticket ID" from ARAdmin.DATABASE_NAME where [COLOR=#ff0000]TYPE = 'INFORMATION ANALYSIS APP' AND (CATEGORY = 'CERPS BI') AND ((TO_DATE(TO_DATE('01/01/1970 00:00:00','MM/DD/YYYY HH24:MI:SS') + ((LAST_UPDATED)/(86400)), 'DD/MM/YYYY HH24:MI:SS')) BETWEEN TO_DATE('01/05/2013 23:59:59','DD/MM/YYYY HH24:MI:SS') AND TO_DATE('30/05/2013 23:59:59','DD/MM/YYYY HH24:MI:SS') )[/COLOR] [COLOR=#0000ff]OR TYPE = 'MIDDLEWARE SERVICES' AND ((TO_DATE(TO_DATE('01/01/1970 00:00:00','MM/DD/YYYY HH24:MI:SS') + ((LAST_UPDATED)/(86400)), 'DD/MM/YYYY HH24:MI:SS')) BETWEEN TO_DATE('01/05/2013 23:59:59','DD/MM/YYYY HH24:MI:SS') AND TO_DATE('30/05/2013 23:59:59','DD/MM/YYYY HH24:MI:SS') )[/COLOR] [COLOR=#008000]OR TYPE = 'MANUFACT AND SUPPLY CHAIN' AND ((TO_DATE(TO_DATE('01/01/1970 00:00:00','MM/DD/YYYY HH24:MI:SS') + ((LAST_UPDATED)/(86400)), 'DD/MM/YYYY HH24:MI:SS')) BETWEEN TO_DATE('01/05/2013 23:59:59','DD/MM/YYYY HH24:MI:SS') AND TO_DATE('30/05/2013 23:59:59','DD/MM/YYYY HH24:MI:SS') )[/COLOR]