Hello.
I was able to make a query which retrieves dates where the TA is
available only for specific TA. To list all TA and periods of time
where they're available I wrote a stored procedure which works in
MySQL 5.
Here is the definition and test data in my tbl_notavailable
(I've c
CF,
>tbl_NotAvailable {
> TAid - int(11)
> StartDate - DateTime
> EndDate - DataTime
>}
>Question one:
>Now, how can I return a calendar of the dates where the TA is AVAILABLE,
>that is the oposite of what is recorded?
You may be better off with an explicit calandar table containing slot
C.F. Scheidecker Antunes wrote:
Question one:
Now, how can I return a calendar of the dates where the TA is AVAILABLE,
that is the oposite of what is recorded?
I want a list of all the available days and times by substracting the
non available times recorded in the table.
I guess I would need t
Hello all,
I have a little table o TAs (teach assistants) with the following MySQL
schema:
tbl_NotAvailable {
TAid - int(11)
StartDate - DateTime
EndDate - DataTime
}
This table logs the times where TAs are NOT available. So If a TA is not
available on Monday from 12:00 to Tuesday