Calendar of Events
Query: SELECT locationid,locationShortName FROM LibPublic.dbo.location WHERE publicDisplay=1 ORDER BY locationShortNameError: Invalid object name 'category'.
Query: SELECT CategoryID AS catid,Name AS catname FROM category WHERE Calendar != '0' AND PublicDisplay = '1' ORDER BY Name ASCError: Invalid object name 'event'.
Query: SELECT DATEPART(d,event_date.TheDate) AS TheDate FROM event_date LEFT JOIN event ON (event.EventID = event_date.EventID) WHERE TheDate >= '2013-02-01' AND TheDate < '03-01-2013' AND (event_date.LocationID=27) AND (event_date.Approved='1') ORDER BY event_date.TheDate,event_date.StartHour,event_date.StartMin
| S | M | T | W | T | F | S | |
|---|---|---|---|---|---|---|---|
| week | 27 |
28 |
29 |
30 |
31 |
1
|
2
|
| week |
3
|
4
|
5
|
6
|
7
|
8
|
9
|
| week |
10
|
11
|
12
|
13
|
14
|
15
|
16
|
| week |
17
|
18
|
19
|
20
|
21
|
22
|
23
|
| week |
24
|
25
|
26
|
27
|
28
|
1 |
2 |
Get More Information About...
Missed an Event? Listen to It Online!
We've recorded authors, poetry events, and other library presentations for you to listen to. See what you may have missed with Listen to Your Library.
This Calendar of Events includes library-sponsored events and public meetings that are held in library meeting rooms.
For information about reserving a library meeting room, please see our Meeting Rooms page.
Community meetings are subject to change without notice.
Pursuant to the Americans with Disabilities Act (ADA), The Pima County Public Library endeavors to ensure that all persons with special needs have access to Library facilities and resources. Persons with special needs may request reasonable accommodation by contacting the individual branch, or the Community Relations Manager at 594-5600.
Query: SELECT '2013-'+holidayAnnualDate AS annualDate,CONVERT(VARCHAR(10),holidaySpecificDate,120) AS specDate,holidayDescription FROM LibPublic.dbo.holidays Error: Database 'LibPublic' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
Query: USE LibPublic; SELECT eventdateid FROM event e LEFT JOIN event_date ON (e.EventID = event_date.EventID) LEFT JOIN location ON (event_date.LocationID = location.LocationID) WHERE CONVERT(VARCHAR(10),TheDate,120) NOT IN ('2013-01-21','2013-09-02','2013-10-14','2013-11-28') AND (event_date.TheDate >= '2013-02-20') AND (event_date.TheDate <= '2013-02-27') AND (event_date.LocationID=27) AND location.publicDisplay NOT IN (0) AND (event_date.Approved='1') ORDER BY event_date.TheDate,event_date.StartHour,event_date.StartMin ,event_date.EndHour, event_date.EndMin, e.Title