Hi,
I am trying to create a query that returns a users availability for the next
ten days using version 4.1.11. A user has 8.5 hours available per day so a
users availability is equal to 8.5 less any bookings they have on that day.
I have a table called Bookings (see below), and each 'Booking' h
From: shaun thornburgh [mailto:[EMAIL PROTECTED]
> Hi,
>
> The following query works out the amount of hours a user has
> been booked for on a particular day:
>
> SELECT
> (SUM(((DATE_FORMAT(B.Booking_End_Date, "%k") * 60 ) +
> DATE_FORMAT(B.Booking_End_Date, "%i")) -
> ((DATE_FORMAT(B.Booking
Hi,
The following query works out the amount of hours a user has been booked for
on a particular day:
SELECT
(SUM(((DATE_FORMAT(B.Booking_End_Date, "%k") * 60 ) +
DATE_FORMAT(B.Booking_End_Date, "%i")) -
((DATE_FORMAT(B.Booking_Start_Date, "%k") * 60 ) +
DATE_FORMAT(B.Booking_Start_Date, "%i")))
Hi,
I have a table called Bookings which holds start times and end times for
appointments, these are held in Booking_Start_Date and Booking_End_Date. I
have a page on my site that runs a query to produce a grid to show
availiability per day for the next ten days for each user of the system.
Use
ot; <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, October 10, 2003 12:37 PM
Subject: Help with a DATETIME Query PLEASE!
> Hi,
>
> I have a table called Bookings which has two important columns;
> Booking_Start_Date and Booking_End_Date. These columns are both
Hi,
I have a table called Bookings which has two important columns;
Booking_Start_Date and Booking_End_Date. These columns are both of type
DATETIME. The following query calculates how many hours are available
between the hours of 09.00 and 17.30 so a user can see at a glance how many
hours th
40688
-->-Original Message-
-->From: shaun thornburgh [mailto:[EMAIL PROTECTED]
-->Sent: Wednesday, October 08, 2003 1:52 AM
-->To: [EMAIL PROTECTED]
-->Subject: Help With a DATETIME Query PLEASE!
-->
-->Hi,
-->
-->I have a table called Bookings which has two important co
On Wed, 2003-10-08 at 09:52, shaun thornburgh wrote:
> Hi,
>
> I have a table called Bookings which has two important columns;
> Booking_Start_Date and Booking_End_Date. These columns are both of type
> DATETIME. The following query calculates how many hours are available
> between the hours of 09
Hi,
I have a table called Bookings which has two important columns;
Booking_Start_Date and Booking_End_Date. These columns are both of type
DATETIME. The following query calculates how many hours are available
between the hours of 09.00 and 17.30 so a user can see at a glance how many
hours they h
s one is my .02... :-)
-Original Message-
From: shaun thornburgh [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 07, 2003 3:51 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Help With a DATETIME Query
Thanks for your reply, but its not an option!
>From: "Dan Greene&q
Thanks for your reply, but its not an option!
From: "Dan Greene" <[EMAIL PROTECTED]>
To: "shaun thornburgh" <[EMAIL PROTECTED]>,
<[EMAIL PROTECTED]>
Subject: RE: Help With a DATETIME Query
Date: Tue, 7 Oct 2003 16:41:04 -0400
I know it's not the a
;s an
option for you, but it's my $0.02.
> -Original Message-
> From: shaun thornburgh [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, October 07, 2003 4:33 PM
> To: [EMAIL PROTECTED]
> Subject: Help With a DATETIME Query
>
>
> Hi,
>
> I have a tabl
Hi,
I have a table called Bookings which has two important columns;
Booking_Start_Date and Booking_End_Date. These columns are both of type
DATETIME. The following query calculates how many hours are available
between the hours of 09.00 and 17.30 so a user can see at a glance how many
hours they h
should get an output like this:
Mon: 0 hrs
Tue: 3.5 hrs
Wed: .
Hope this helps,
Cheers,
Andrew
-Original Message-
From: shaun thornburgh [mailto:[EMAIL PROTECTED]
Sent: Monday 06 October 2003 20:29
To: [EMAIL PROTECTED]
Subject: Help With a DATETIME Query
Hi,
I have a table
should get an output like this:
Mon: 0 hrs
Tue: 3.5 hrs
Wed: .
Hope this helps,
Cheers,
Andrew
-Original Message-
From: shaun thornburgh [mailto:[EMAIL PROTECTED]
Sent: Monday 06 October 2003 20:29
To: [EMAIL PROTECTED]
Subject: Help With a DATETIME Query
Hi,
I have a table
Hi,
I have a table called Bookings which has two important columns;
Booking_Start_Date and Booking_End_Date. These columns are both of type
DATETIME. The following query calculates how many hours are available
between the hours of 09.00 and 17.30 so a user can see at a glance how many
hours they h
Hi,
I have a table called Bookings which has two important columns;
Booking_Start_Date and Booking_End_Date. These columns are both of type
DATETIME. The following query calculates how many hours are available
between the hours of 09.00 and 17.30 so a user can see at a glance how many
hours they h
17 matches
Mail list logo
