----- Original Message ----- > From: "Rocio Gomez Escribano" <[email protected]>
> 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
