List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:May 24 2011 10:32am
Subject:Re: timediff hours and days
View as plain text  
----- Original Message -----

> From: "Rocio Gomez Escribano" <r.gomez@stripped>

> 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 

Thread
timediff hours and daysRocio Gomez Escribano24 May
  • Re: timediff hours and daysJohan De Meersman24 May