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
com/doc/mysql/en/date-and-time-functions.html Mathias > Selon Gyurasits Zoltán <[EMAIL PROTECTED]>: > > > Hello All! > > > > > > I would like to calculate the hour counts from 2 'datetime'. > > Example: 2005-07-27 18:00 and 2005-07-27 19:30 => 1,5 ho

Re: Hour counts

2005-07-27 Thread mfatene
sql/en/date-and-time-functions.html Mathias Selon Gyurasits Zoltán <[EMAIL PROTECTED]>: > Hello All! > > > I would like to calculate the hour counts from 2 'datetime'. > Example: 2005-07-27 18:00 and 2005-07-27 19:30 => 1,5 hour > > I try this but

Re: Hour counts

2005-07-27 Thread Jason Pyeron
:00| +-+-++-+ On Wed, 27 Jul 2005, [iso-8859-2] Gyurasits Zolt?n wrote: Hello All! I would like to calculate the hour counts from 2 'datetime'. Example: 2005-07-27 18:00 and 2005-07-27 19:30 => 1,5 hour I try this but not good! R1 : munkaido_en

RE: Hour counts

2005-07-27 Thread Terry Spencer
_TIMESTAMP() and subtract one form the other. Divide the result by 3600 (60*60 = seconds in an hour) to obtain the fractional hours. Terry -Original Message----- From: Gyurasits Zoltán [mailto:[EMAIL PROTECTED] Sent: 27 July 2005 17:12 To: mysql@lists.mysql.com Subject: Hour counts Hello Al

Re: Hour counts

2005-07-27 Thread Martijn Tonies
like to calculate the hour counts from 2 'datetime'. Example: 2005-07-27 18:00 and 2005-07-27 19:30 => 1,5 hour I try this but not good! R1 : munkaido_end-munkaido_start /simple substract/ R2 : ROUND(ROUND((end-start)/1)+ (((end-start)/1000-(ROUND((end-start)/1)*10))/6

Hour counts

2005-07-27 Thread Gyurasits Zoltán
Hello All! I would like to calculate the hour counts from 2 'datetime'. Example: 2005-07-27 18:00 and 2005-07-27 19:30 => 1,5 hour I try this but not good! R1 : munkaido_end-munkaido_start /simple substract/ R2 : ROUND(ROUND((end-start)/1)+ (((end-start)/1000-(ROU