Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT usr.tus_cod_usr AS "COD USUARIO",
- usr.tus_fec_ult_con AS "ULTIMA CONEXAO SAT",
- ADD_MONTHS(usr.tus_fec_ult_con, 18) AS "DATA INATIVACAO"
- FROM tab_user usr
- WHERE usr.tus_orig_usr IN (1,4,5)
- AND usr.tus_status=1
- AND MONTHS_BETWEEN(SYSDATE, usr.tus_fec_ult_con) > 17
- AND MONTHS_BETWEEN(SYSDATE, usr.tus_fec_ult_con) < 18
- ORDER BY usr.tus_fec_ult_con DESC;
Advertisement
Add Comment
Please, Sign In to add comment