Re: Hour counts

2005-07-28 Thread 2wsxdr5
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

Re: Hour counts

2005-07-27 Thread Martijn Tonies
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

RE: Hour counts

2005-07-27 Thread Terry Spencer
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

Re: Hour counts

2005-07-27 Thread Jason Pyeron
mysql select *,timediff(end,start) from foo; +-+-++-+ | start | end | id | timediff(end,start) | +-+-++-+ | 2005-07-14 15:00:00 |

Re: Hour counts

2005-07-27 Thread mfatene
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

Re: Hour counts

2005-07-27 Thread mfatene
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

Re: Hour counts

2005-07-27 Thread Gyurasits Zoltán
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

Re: Hour counts

2005-07-27 Thread SGreen
[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

Re: Hour counts

2005-07-27 Thread Gyurasits Zoltán
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

Re: Hour counts

2005-07-27 Thread Eric Bergen
, 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