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 processo

Re: Hour counts

2005-07-27 Thread Eric Bergen
L PROTECTED]>; 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 http://www.upscene.com

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: 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:

Re: Hour counts

2005-07-27 Thread SGreen
ot;Martijn Tonies" <[EMAIL PROTECTED]> > To: "Gyurasits Zoltán" <[EMAIL PROTECTED]>; > Sent: Wednesday, July 27, 2005 6:31 PM > Subject: Re: Hour counts > > > > Hi, > > > > Check out the TIMEDIFF function. > > > > With regard

Re: Hour counts

2005-07-27 Thread Gyurasits Zoltán
ay, 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 the forum! h

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 Jason Pyeron
mysql> select *,timediff(end,start) from foo; +-+-++-+ | start | end | id | timediff(end,start) | +-+-++-+ | 2005-07-14 15:00:00 | 2005-07-1

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 res

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 t