Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select distinct(
- IF(STR_TO_DATE(vencimiento, '%d-%m-%Y') > NOW(), "VENCIDA",
- IF(DATE_ADD(STR_TO_DATE(vencimiento, '%d-%m-%Y'), INTERVAL 2 MONTH) > NOW(), "POR VENCER", "VIGENTE"))) as estado
- from tbl_garantias_clientes
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement