subject:"time calculate"

RE: time calculate

2001-10-18 Thread Ravi Raman

change it to hours, then add the difference in hours... that will probably do what you're looking for. hth. -ravi. -Original Message- From: Sommai Fongnamthip [mailto:[EMAIL PROTECTED]] Sent: October 18, 2001 4:27 AM To: [EMAIL PROTECTED] Subject: time calculate hi, I'

time calculate

2001-10-18 Thread Sommai Fongnamthip

hi, I'd like to calculate hour usage between 2 time value. Which data type I should to use in mysql? and how to write sql to calculate hour usage especially when the second time is in the next day?? Thanks SF - Befor