18/11/2010, 08:41
|
 | | | Fecha de Ingreso: febrero-2006 Ubicación: Bogotá, Colombia
Mensajes: 1.866
Antigüedad: 19 años Puntos: 96 | |
| Respuesta: Diferencia entre fechas
Saludos Cita: Date functions
Sometimes, you need to know how the difference between two timestamps. For this, DB2 provides a built in function called TIMESTAMPDIFF(). The value returned is an approximation, however, because it does not account for leap years and assumes only 30 days per month. Here is an example of how to find the approximate difference in time between two dates:
timestampdiff (<n>, char(
timestamp('2002-11-30-00.00.00')-
timestamp('2002-11-08-00.00.00')))
Fuente: Click Aqui
__________________
:.:Nano.:: @nano_hard - Retornando al foro |