Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> SELECT *,CURRENT_DATE () as fechaActual,(DAY (CURRENT_DATE())- DAY(fechaEntrega)) as RetrasoEnDias from ticket ;
- +-----------+----------+-------------+-------------+--------------+--------+-------------+---------------+
- | id_ticket | id_socio | id_empleado | fechaSalida | fechaEntrega | precio | fechaActual | RetrasoEnDias |
- +-----------+----------+-------------+-------------+--------------+--------+-------------+---------------+
- | 1 | 15 | 315 | 2012-02-01 | 2012-02-04 | 25 | 2012-02-06 | 2 |
- +-----------+----------+-------------+-------------+--------------+--------+-------------+---------------+
- 1 row in set (0.00 sec)
Add Comment
Please, Sign In to add comment