Eamon Daly
- Original Message -
From: "listsql listsql" <[EMAIL PROTECTED]>
To: "Eamon Daly" <[EMAIL PROTECTED]>; "mysql" <[EMAIL PROTECTED]>
Sent: Tuesday, November 09, 2004 11:05 AM
Subject: Re: Emulating timediff in 4.0 ?
Thanks Eamon,
I was tr
you've got that going for you.
>
> ____________
> Eamon Daly
>
>
>
>
> - Original Message -
> From: "listsql listsql" <[EMAIL PROTECTED]>
> To: "mysql" <[EMAIL PROTECTED]>
&
5261
date 2 in seconds: 883634399
diff in seconds: -169138
diff in hh:mm:ss: -46:58:58
So you've got that going for you.
Eamon Daly
- Original Message -
From: "listsql listsql" <[EMAIL PROTECTED]>
To: "mysql" <[EMAIL P
TIMEDIFF(expr,expr2)
TIMEDIFF() returns the time between the start time expr and the
end time expr2. expr and expr2 are time or date-and-time expressions,
but both must be of the same type.
mysql> SELECT TIMEDIFF('1997-12-31 23:59:59.01',
-> '1997-12-30 01:01:01.02'
