[PHP-DB] Re: Calculating time unused

David Robley [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] In article [EMAIL PROTECTED], [EMAIL PROTECTED] says... Hi, I have a table called Bookings which has two important columns; Booking_Start_Time and Booking_End_Time. These columns are both of type DATETIME. Given

[PHP-DB] Re: Calculating time unused

Shaun [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] David Robley [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] In article [EMAIL PROTECTED], [EMAIL PROTECTED] says... Hi, I have a table called Bookings which has two important columns; Booking_Start_Time

[PHP-DB] Re: Calculating time unused

In article [EMAIL PROTECTED], [EMAIL PROTECTED] says... Hi, I have a table called Bookings which has two important columns; Booking_Start_Time and Booking_End_Time. These columns are both of type DATETIME. Given any day how can I calculate how many hours are available between the hours of