timediff hours and days

2011-05-24 Thread 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?

 

Thanks!

 

Rocío Gómez Escribano

 mailto:r.sanc...@ingenia-soluciones.com r.go...@ingenia-soluciones.com

 

Descripción: cid:image002.jpg@01CB8CB6.ADEBA830

Polígono Campollano C/F, nº21T

02007 Albacete (España)

Tlf:967-504-513  Fax: 967-504-513

www.ingenia-soluciones.com

 



Re: timediff hours and days

2011-05-24 Thread Johan De Meersman
- Original Message -

 From: Rocio Gomez Escribano r.go...@ingenia-soluciones.com

 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-functions.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