Guest User

Untitled

a guest
Jun 17th, 2018
190
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.67 KB | None | 0 0
  1.  
  2. mysql> SELECT *,CURRENT_DATE () as fechaActual,(DAY (CURRENT_DATE())- DAY(fechaEntrega)) as RetrasoEnDias from ticket ;
  3. +-----------+----------+-------------+-------------+--------------+--------+-------------+---------------+
  4. | id_ticket | id_socio | id_empleado | fechaSalida | fechaEntrega | precio | fechaActual | RetrasoEnDias |
  5. +-----------+----------+-------------+-------------+--------------+--------+-------------+---------------+
  6. |         1 |       15 |         315 | 2012-02-01  | 2012-02-04   |     25 | 2012-02-06  |             2 |
  7. +-----------+----------+-------------+-------------+--------------+--------+-------------+---------------+
  8. 1 row in set (0.00 sec)
Add Comment
Please, Sign In to add comment