Eric Bergen wrote:
This does make his code fall under the limitations of unix timestamps.
In 30 years or so when we are all retired millionaires ;) some poor
intern is going to have to figure out why the hour diff calculation is
failing.
Long before then we will all be using 64 bit
Hi,
Check out the TIMEDIFF function.
With regards,
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com
I would like
There are a few options, for more information see
http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html
TIMESTAMPDIFF(interval,datetime_expr1,datetime_expr2)
Returns the integer difference between the date or datetime expressions
datetime_expr1 and datetime_expr2. The unit for the
mysql select *,timediff(end,start) from foo;
+-+-++-+
| start | end | id | timediff(end,start) |
+-+-++-+
| 2005-07-14 15:00:00 |
Hi,
You can use Timediff :
mysql SELECT TIMEDIFF('2005-07-27 18:00', '2005-07-27 19:30');
+--+
| TIMEDIFF('2005-07-27 18:00', '2005-07-27 19:30') |
+--+
| -01:30:00
Hi,
You can use Timediff :
mysql SELECT TIMEDIFF('2005-07-27 18:00', '2005-07-27 19:30');
+--+
| TIMEDIFF('2005-07-27 18:00', '2005-07-27 19:30') |
+--+
| -01:30:00
Subject: Re: Hour counts
Hi,
Check out the TIMEDIFF function.
With regards,
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http
[EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Wednesday, July 27, 2005 6:31 PM
Subject: Re: Hour counts
Hi,
Check out the TIMEDIFF function.
With regards,
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle MS
SQL
Server
Upscene Productions
Working!!! Thank you!!!
- Original Message -
From: [EMAIL PROTECTED]
To: Gyurasits Zoltán [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Wednesday, July 27, 2005 7:09 PM
Subject: Re: Hour counts
Gyurasits Zoltán [EMAIL PROTECTED] wrote on 07/27/2005 12:57:42 PM:
TIMESTAMP
, July 27, 2005 6:31 PM
Subject: Re: Hour counts
Hi,
Check out the TIMEDIFF function.
With regards,
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle MS
SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check
10 matches
Mail list logo