[PHP-DB] Re: Calculating time unused

2003-10-03 Thread Shaun
"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 column

[PHP-DB] Re: Calculating time unused

2003-10-03 Thread Shaun
"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 > > D

[PHP-DB] Re: Calculating time unused

2003-09-30 Thread David Robley
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 ho