timediff hours and days
am 24.05.2011 11:39:12 von Rocio Gomez Escribano
------=_NextPart_000_0013_01CC1A07.34D99630
Content-Type: multipart/alternative;
boundary="----=_NextPart_001_0014_01CC1A07.34D99630"
------=_NextPart_001_0014_01CC1A07.34D99630
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hello! Have this anwer from mysql,=20
+----------------------------------------+
| TIMEDIFF(Date,now()) |
-+----------------------------------------+
| 70:56:06 |
+----------------------------------------+
=20
Is it possible to convert it to -> days, hour, minutes?
=20
Thanks!
=20
Roc=EDo G=F3mez Escribano
=
r.gomez@ingenia-soluciones.com
=20
Descripci=F3n: cid:image002.jpg@01CB8CB6.ADEBA830
Pol=EDgono Campollano C/F, n=BA21T
02007 Albacete (Espa=F1a)
Tlf:967-504-513 Fax: 967-504-513
www.ingenia-soluciones.com
=20
------=_NextPart_001_0014_01CC1A07.34D99630
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" =
xmlns=3D"http://www.w3.org/TR/REC-html40">
http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
12 (filtered medium)">
vlink=3Dpurple>
lang=3DEN-US>Hello! Have this anwer from mysql,
class=3DMsoNormal>
lang=3DEN-US>+----------------------------------------+
=
lang=3DEN-US>| =A0= A0 =A0 =
=A0TIMEDIFF(Date,now()) |
class=3DMsoNormal>
lang=3DEN-US>-+----------------------------------------+
>
| 70:56:06 =
=A0=
=A0|
p>
lang=3DEN-US>+----------------------------------------+=
lang=3DEN-US>
lang=3DEN-US>Is it possible to convert it to -> days, hour, =
minutes?
lang=3DEN-US>
lang=3DEN-US>Thanks!
lang=3DEN-US>
lang=3DES-PE style=3D'font-size:10.0pt;color:#0070C0'>Roc=EDo G=F3mez =
Escribano
lang=3DES-PE style=3D'font-size:10.0pt;color:#9D9D9D'>
href=3D"mailto:r.sanchez@ingenia-soluciones.com">
style=3D'color:blue'>r.gomez@ingenia-soluciones.com=
style=3D'color:blue'>
class=3DMsoNormal>
![]()
border=3D0 width=3D181 height=3D74 id=3D"Imagen_x0020_1" =
src=3D"cid:image001.jpg@01CC1A07.286E43F0" alt=3D"Descripci=F3n: =
cid:image002.jpg@01CB8CB6.ADEBA830">
style=3D'font-size:12.0pt;color:blue'>
class=3DMsoNormal>
style=3D'font-size:10.0pt;color:#A6A6A6'>Pol=EDgono Campollano C/F, =
n=BA21T
style=3D'font-size:10.0pt;color:blue'>
class=3DMsoNormal>
02007 =
Albacete (Espa=F1a)
lang=3DEN-GB =
style=3D'font-size:10.0pt;color:#9D9D9D'>Tlf:967-504-513 Fax: =
967-504-513
style=3D'font-size:10.0pt;color:#A6A6A6'>
href=3D"www.ingenia-soluciones.com" =
title=3D"blocked::www.ingenia-soluciones.com">
style=3D'color:#9D9D9D'>www.ingenia-soluciones.com
lang=3DEN-GB =
style=3D'font-size:10.0pt;color:#A6A6A6'>
class=3DMsoNormal>
lang=3DEN-US>
Re: timediff hours and days
am 24.05.2011 12:32:59 von Johan De Meersman
--=_09e6b257-97eb-49c7-8200-61baa698d9ef
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
----- Original Message -----
> From: "Rocio Gomez Escribano"
> Hello! Have this anwer from mysql,
> +----------------------------------------+
> | TIMEDIFF(Date,now()) |
> -+----------------------------------------+
> | 70:56:06 |
> +----------------------------------------+
> Is it possible to convert it to -> days, hour, minutes?
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functio ns.html#function_date-format can give you that in a single string; on the same page there's other stuff that allows you do do it into separate fields if you prefer.
I sometimes feel the documentation is the best part about MySQL :-p
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel
--=_09e6b257-97eb-49c7-8200-61baa698d9ef--