PHWinfo - Afficher un message

17/10/2007, 02h50

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 ?

17/10/2007, 02h50	#3
crybaby Messages: n/a Hébergeur:	Re: formating mysql timediff output 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 ?