Chris, This is how I do it:
SELECT UNIX_TIMESTAMP(time_sign_out) -UNIX_TIMESTAMP(time_sign_in)/3600 AS hours HTH! Cory On Wed, 2002-10-30 at 13:50, Raymer, Chris wrote: > Having trouble getting the syntax to calculate the time difference given 2 dates >like so: > > A.) 2002-01-02 21:33:00 > B.) 2002-01-03 00:12:00 > > In SQL Server could DateDiff. Have tried combinations of TO_DAYS, MINUTE,HOUR etc >to no avail. Please Help. > > Chris Raymer > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
