On Oct 16, 5:21 pm, "Paul Lautman" <paul.laut...@btinternet.com>
wrote:
> crybaby wrote:
> > Is there a way to format output of timediff in following format: day
> > hours minutes seconds?
>
> > eg:
> > timediff(Oct 16 2007 130000 - Oct 15 110000) = 1 days 2 hours 00
> > minutes 00 secs
>
> Yes

How do you do this in mysql so that format is in ddhhmmss,
someFormatFunction(timediff(Oct 16 2007 130000 - Oct 15 110000)) = 1
days 2 hours 00 minutes 00 secs ?