Upcoming Programs

-40224
1513346400, 1513382400, NOW:1513386624
Friday, December 15, 9:00 AM
-34824
1513351800, 1513355400, NOW:1513386624
Friday, December 15, 10:30 AM
46176
1513432800, 1513461600, NOW:1513386624
Saturday, December 16, 9:00 AM

Thinking Money: Traveling Exhibition for Tweens, Teens & the Adults in their Lives

Saturday, December 16, 9:00 a.m. - 5:00 p.m.
Newport Branch
Teen Program Adult Program 
53376
1513440000, 1513447200, NOW:1513386624
Saturday, December 16, 11:00 AM

Super Saturday: Holiday Movies

Saturday, December 16, 11:00 a.m. - 1:00 p.m.
Carrico/Ft. Thomas Branch
Childrens Program 
53376
1513440000, 1513441800, NOW:1513386624
Saturday, December 16, 11:00 AM

Baby Sign Storytime

Saturday, December 16, 11:00 a.m. - 11:30 a.m.
Cold Spring Branch
Childrens Program 
60576
1513447200, 1513454400, NOW:1513386624
Saturday, December 16, 1:00 PM

Thinking Money: Make an Ornament

Saturday, December 16, 1:00 p.m. - 3:00 p.m.
Newport Branch
Teen Program Adult Program 
64176
1513450800, 1513454400, NOW:1513386624
Saturday, December 16, 2:00 PM

Super Saturday: Christmas Yoga

Saturday, December 16, 2:00 p.m. - 3:00 p.m.
Cold Spring Branch
Childrens Program 
143376
1513530000, 1513548000, NOW:1513386624
Sunday, December 17, 12:00 PM

Thinking Money: Traveling Exhibition for Tweens, Teens & the Adults in their Lives

Sunday, December 17, 12:00 p.m. - 5:00 p.m.
Newport Branch
Teen Program Adult Program 
146976
1513533600, 1513548000, NOW:1513386624
Sunday, December 17, 1:00 PM

Family Card and Board Game Day

Sunday, December 17, 1:00 p.m. - 5:00 p.m.
Cold Spring Branch
Teen Program Adult Program 
218976
1513605600, 1513648800, NOW:1513386624
Monday, December 18, 9:00 AM
247776
1513634400, 1513648800, NOW:1513386624
Monday, December 18, 5:00 PM
253176
1513639800, 1513645200, NOW:1513386624
Monday, December 18, 6:30 PM
305376
1513692000, 1513735200, NOW:1513386624
Tuesday, December 19, 9:00 AM
312576
1513699200, 1513702800, NOW:1513386624
Tuesday, December 19, 11:00 AM
339576
1513726200, 1513731600, NOW:1513386624
Tuesday, December 19, 6:30 PM
341376
1513728000, 1513731600, NOW:1513386624
Tuesday, December 19, 7:00 PM
391776
1513778400, 1513821600, NOW:1513386624
Wednesday, December 20, 9:00 AM
422376
1513809000, 1513789200, NOW:1513386624
Wednesday, December 20, 5:30 PM
478176
1513864800, 1513908000, NOW:1513386624
Thursday, December 21, 9:00 AM
514176
1513900800, 1513906200, NOW:1513386624
Thursday, December 21, 7:00 PM
564576
1513951200, 1513987200, NOW:1513386624
Friday, December 22, 9:00 AM
600576
1513987200, 1513998000, NOW:1513386624
Friday, December 22, 7:00 PM
650976
1514037600, 1514066400, NOW:1513386624
Saturday, December 23, 9:00 AM
737376
1514124000, 1514134800, NOW:1513386624
Sunday, December 24, 9:00 AM
823776
1514210400, 1514221200, NOW:1513386624
Monday, December 25, 9:00 AM
910176
1514296800, 1514340000, NOW:1513386624
Tuesday, December 26, 9:00 AM
996576
1514383200, 1514426400, NOW:1513386624
Wednesday, December 27, 9:00 AM
1082976
1514469600, 1514512800, NOW:1513386624
Thursday, December 28, 9:00 AM
1118976
1514505600, 1514511000, NOW:1513386624
Thursday, December 28, 7:00 PM
1169376
1514556000, 1514592000, NOW:1513386624
Friday, December 29, 9:00 AM
1255776
1514642400, 1514671200, NOW:1513386624
Saturday, December 30, 9:00 AM
1263876
1514650500, 1514654100, NOW:1513386624
Saturday, December 30, 11:15 AM
1268376
1514655000, 1514658600, NOW:1513386624
Saturday, December 30, 12:30 PM
1352976
1514739600, 1514757600, NOW:1513386624
Sunday, December 31, 12:00 PM
1514976
1514901600, 1514944800, NOW:1513386624
Tuesday, January 2, 9:00 AM
1522176
1514908800, 1514912400, NOW:1513386624
Tuesday, January 2, 11:00 AM
1540176
1514926800, 1514930400, NOW:1513386624
Tuesday, January 2, 4:00 PM
1550976
1514937600, 1514941200, NOW:1513386624
Tuesday, January 2, 7:00 PM
1601376
1514988000, 1515031200, NOW:1513386624
Wednesday, January 3, 9:00 AM
1626576
1515013200, 1515016800, NOW:1513386624
Wednesday, January 3, 4:00 PM
1687776
1515074400, 1515117600, NOW:1513386624
Thursday, January 4, 9:00 AM
1709376
1515096000, 1515103200, NOW:1513386624
Thursday, January 4, 3:00 PM
1721976
1515108600, 1515115800, NOW:1513386624
Thursday, January 4, 6:30 PM
1774176
1515160800, 1515196800, NOW:1513386624
Friday, January 5, 9:00 AM
1806576
1515193200, 1515207600, NOW:1513386624
Friday, January 5, 6:00 PM
1860576
1515247200, 1515276000, NOW:1513386624
Saturday, January 6, 9:00 AM
1957776
1515344400, 1515362400, NOW:1513386624
Sunday, January 7, 12:00 PM
2033376
1515420000, 1515463200, NOW:1513386624
Monday, January 8, 9:00 AM
2044176
1515430800, 1515434400, NOW:1513386624
Monday, January 8, 12:00 PM
2062176
1515448800, 1515456000, NOW:1513386624
Monday, January 8, 5:00 PM
2065776
1515452400, 1515459600, NOW:1513386624
Monday, January 8, 6:00 PM
2119776
1515506400, 1515549600, NOW:1513386624
Tuesday, January 9, 9:00 AM
2123376
1515510000, 1515513600, NOW:1513386624
Tuesday, January 9, 10:00 AM
2126976
1515513600, 1515517200, NOW:1513386624
Tuesday, January 9, 11:00 AM
2144976
1515531600, 1515535200, NOW:1513386624
Tuesday, January 9, 4:00 PM
2206176
1515592800, 1515636000, NOW:1513386624
Wednesday, January 10, 9:00 AM
2224176
1515610800, 1515614400, NOW:1513386624
Wednesday, January 10, 2:00 PM
2227776
1515614400, 1515621600, NOW:1513386624
Wednesday, January 10, 3:00 PM
2231376
1515618000, 1515621600, NOW:1513386624
Wednesday, January 10, 4:00 PM
2240376
1515627000, 1515629700, NOW:1513386624
Wednesday, January 10, 6:30 PM
2292576
1515679200, 1515722400, NOW:1513386624
Thursday, January 11, 9:00 AM
2315976
1515702600, 1515709800, NOW:1513386624
Thursday, January 11, 3:30 PM
2317776
1515704400, 1515708000, NOW:1513386624
Thursday, January 11, 4:00 PM
2326776
1515713400, 1515718800, NOW:1513386624
Thursday, January 11, 6:30 PM
2378976
1515765600, 1515794400, NOW:1513386624
Friday, January 12, 9:00 AM
2393376
1515780000, 1515783600, NOW:1513386624
Friday, January 12, 1:00 PM
2407776
1515794400, 1515776400, NOW:1513386624
Friday, January 12, 5:00 PM
2414976
1515801600, 1515807000, NOW:1513386624
Friday, January 12, 7:00 PM
2465376
1515852000, 1515880800, NOW:1513386624
Saturday, January 13, 9:00 AM
2562576
1515949200, 1515967200, NOW:1513386624
Sunday, January 14, 12:00 PM
2638176
1516024800, 1516068000, NOW:1513386624
Monday, January 15, 9:00 AM
2639976
1516026600, 1516028400, NOW:1513386624
Monday, January 15, 9:30 AM
2641776
1516028400, 1516032000, NOW:1513386624
Monday, January 15, 10:00 AM
2647176
1516033800, 1516035600, NOW:1513386624
Monday, January 15, 11:30 AM
2663376
1516050000, 1516053600, NOW:1513386624
Monday, January 15, 4:00 PM
2666976
1516053600, 1516060800, NOW:1513386624
Monday, January 15, 5:00 PM
2672376
1516059000, 1516064400, NOW:1513386624
Monday, January 15, 6:30 PM
2674176
1516060800, 1516067100, NOW:1513386624
Monday, January 15, 7:00 PM
2674176
1516060800, 1516063500, NOW:1513386624
Monday, January 15, 7:00 PM
2724576
1516111200, 1516154400, NOW:1513386624
Tuesday, January 16, 9:00 AM
2728176
1516114800, 1516118400, NOW:1513386624
Tuesday, January 16, 10:00 AM
2728176
1516114800, 1516117500, NOW:1513386624
Tuesday, January 16, 10:00 AM
2731776
1516118400, 1516121100, NOW:1513386624
Tuesday, January 16, 11:00 AM
2749776
1516136400, 1516140000, NOW:1513386624
Tuesday, January 16, 4:00 PM
2749776
1516136400, 1516140000, NOW:1513386624
Tuesday, January 16, 4:00 PM
2760576
1516147200, 1516150800, NOW:1513386624
Tuesday, January 16, 7:00 PM
2810976
1516197600, 1516240800, NOW:1513386624
Wednesday, January 17, 9:00 AM
2812776
1516199400, 1516202100, NOW:1513386624
Wednesday, January 17, 9:30 AM
2814576
1516201200, 1516204800, NOW:1513386624
Wednesday, January 17, 10:00 AM
2814576
1516201200, 1516203000, NOW:1513386624
Wednesday, January 17, 10:00 AM
2818176
1516204800, 1516206600, NOW:1513386624
Wednesday, January 17, 11:00 AM
2818176
1516204800, 1516207500, NOW:1513386624
Wednesday, January 17, 11:00 AM
2832576
1516219200, 1516226400, NOW:1513386624
Wednesday, January 17, 3:00 PM
2836176
1516222800, 1516226400, NOW:1513386624
Wednesday, January 17, 4:00 PM
2841576
1516228200, 1516233600, NOW:1513386624
Wednesday, January 17, 5:30 PM
2846976
1516233600, 1516237200, NOW:1513386624
Wednesday, January 17, 7:00 PM
2897376
1516284000, 1516327200, NOW:1513386624
Thursday, January 18, 9:00 AM
2899176
1516285800, 1516288500, NOW:1513386624
Thursday, January 18, 9:30 AM
2899176
1516285800, 1516287600, NOW:1513386624
Thursday, January 18, 9:30 AM
2900976
1516287600, 1516291200, NOW:1513386624
Thursday, January 18, 10:00 AM
2902776
1516289400, 1516292100, NOW:1513386624
Thursday, January 18, 10:30 AM
2902776
1516289400, 1516292100, NOW:1513386624
Thursday, January 18, 10:30 AM
2920776
1516307400, 1516314600, NOW:1513386624
Thursday, January 18, 3:30 PM
2922576
1516309200, 1516312800, NOW:1513386624
Thursday, January 18, 4:00 PM
2931576
1516318200, 1516325400, NOW:1513386624
Thursday, January 18, 6:30 PM
2931576
1516318200, 1516323600, NOW:1513386624
Thursday, January 18, 6:30 PM
2983776
1516370400, 1516406400, NOW:1513386624
Friday, January 19, 9:00 AM
3019776
1516406400, 1516417200, NOW:1513386624
Friday, January 19, 7:00 PM
3019776
1516406400, 1516413600, NOW:1513386624
Friday, January 19, 7:00 PM
3070176
1516456800, 1516485600, NOW:1513386624
Saturday, January 20, 9:00 AM
3073776
1516460400, 1516463100, NOW:1513386624
Saturday, January 20, 10:00 AM
3079176
1516465800, 1516468500, NOW:1513386624
Saturday, January 20, 11:30 AM
3084576
1516471200, 1516474800, NOW:1513386624
Saturday, January 20, 1:00 PM
3088176
1516474800, 1516478400, NOW:1513386624
Saturday, January 20, 2:00 PM
3167376
1516554000, 1516572000, NOW:1513386624
Sunday, January 21, 12:00 PM
3170976
1516557600, 1516572000, NOW:1513386624
Sunday, January 21, 1:00 PM
3244776
1516631400, 1516633200, NOW:1513386624
Monday, January 22, 9:30 AM
3246576
1516633200, 1516636800, NOW:1513386624
Monday, January 22, 10:00 AM
3251976
1516638600, 1516640400, NOW:1513386624
Monday, January 22, 11:30 AM
3268176
1516654800, 1516658400, NOW:1513386624
Monday, January 22, 4:00 PM
3277176
1516663800, 1516669200, NOW:1513386624
Monday, January 22, 6:30 PM
3278976
1516665600, 1516668300, NOW:1513386624
Monday, January 22, 7:00 PM
3332976
1516719600, 1516722300, NOW:1513386624
Tuesday, January 23, 10:00 AM
3336576
1516723200, 1516725900, NOW:1513386624
Tuesday, January 23, 11:00 AM
3354576
1516741200, 1516744800, NOW:1513386624
Tuesday, January 23, 4:00 PM
3354576
1516741200, 1516744800, NOW:1513386624
Tuesday, January 23, 4:00 PM
3365376
1516752000, 1516755600, NOW:1513386624
Tuesday, January 23, 7:00 PM
3417576
1516804200, 1516806900, NOW:1513386624
Wednesday, January 24, 9:30 AM
3419376
1516806000, 1516809600, NOW:1513386624
Wednesday, January 24, 10:00 AM
3419376
1516806000, 1516807800, NOW:1513386624
Wednesday, January 24, 10:00 AM
3422976
1516809600, 1516811400, NOW:1513386624
Wednesday, January 24, 11:00 AM
3422976
1516809600, 1516812300, NOW:1513386624
Wednesday, January 24, 11:00 AM
3440976
1516827600, 1516831200, NOW:1513386624
Wednesday, January 24, 4:00 PM
3440976
1516827600, 1516834800, NOW:1513386624
Wednesday, January 24, 4:00 PM
3503976
1516890600, 1516893300, NOW:1513386624
Thursday, January 25, 9:30 AM
3503976
1516890600, 1516892400, NOW:1513386624
Thursday, January 25, 9:30 AM
3505776
1516892400, 1516896000, NOW:1513386624
Thursday, January 25, 10:00 AM
3507576
1516894200, 1516896900, NOW:1513386624
Thursday, January 25, 10:30 AM
3507576
1516894200, 1516896900, NOW:1513386624
Thursday, January 25, 10:30 AM
3527376
1516914000, 1516917600, NOW:1513386624
Thursday, January 25, 4:00 PM
3536376
1516923000, 1516928400, NOW:1513386624
Thursday, January 25, 6:30 PM
3539976
1516926600, 1516930200, NOW:1513386624
Thursday, January 25, 7:30 PM
3602976
1516989600, 1516993200, NOW:1513386624
Friday, January 26, 1:00 PM
3620976
1517007600, 1517022000, NOW:1513386624
Friday, January 26, 6:00 PM
3678576
1517065200, 1517067900, NOW:1513386624
Saturday, January 27, 10:00 AM
3680376
1517067000, 1517069700, NOW:1513386624
Saturday, January 27, 10:30 AM
3692976
1517079600, 1517086800, NOW:1513386624
Saturday, January 27, 2:00 PM
3692976
1517079600, 1517083200, NOW:1513386624
Saturday, January 27, 2:00 PM
3696576
1517083200, 1517086800, NOW:1513386624
Saturday, January 27, 3:00 PM
3849576
1517236200, 1517238000, NOW:1513386624
Monday, January 29, 9:30 AM
3851376
1517238000, 1517241600, NOW:1513386624
Monday, January 29, 10:00 AM
3856776
1517243400, 1517245200, NOW:1513386624
Monday, January 29, 11:30 AM
3872976
1517259600, 1517263200, NOW:1513386624
Monday, January 29, 4:00 PM
3876576
1517263200, 1517268600, NOW:1513386624
Monday, January 29, 5:00 PM
3880176
1517266800, 1517270400, NOW:1513386624
Monday, January 29, 6:00 PM
3883776
1517270400, 1517273100, NOW:1513386624
Monday, January 29, 7:00 PM
3937776
1517324400, 1517328000, NOW:1513386624
Tuesday, January 30, 10:00 AM
3937776
1517324400, 1517327100, NOW:1513386624
Tuesday, January 30, 10:00 AM
3941376
1517328000, 1517330700, NOW:1513386624
Tuesday, January 30, 11:00 AM
3959376
1517346000, 1517349600, NOW:1513386624
Tuesday, January 30, 4:00 PM
3968376
1517355000, 1517362200, NOW:1513386624
Tuesday, January 30, 6:30 PM
4022376
1517409000, 1517411700, NOW:1513386624
Wednesday, January 31, 9:30 AM
4024176
1517410800, 1517414400, NOW:1513386624
Wednesday, January 31, 10:00 AM
4024176
1517410800, 1517412600, NOW:1513386624
Wednesday, January 31, 10:00 AM
4027776
1517414400, 1517416200, NOW:1513386624
Wednesday, January 31, 11:00 AM
4027776
1517414400, 1517417100, NOW:1513386624
Wednesday, January 31, 11:00 AM
4042176
1517428800, 1517436000, NOW:1513386624
Wednesday, January 31, 3:00 PM
4045776
1517432400, 1517436000, NOW:1513386624
Wednesday, January 31, 4:00 PM
4108776
1517495400, 1517498100, NOW:1513386624
Thursday, February 1, 9:30 AM
4108776
1517495400, 1517497200, NOW:1513386624
Thursday, February 1, 9:30 AM
4110576
1517497200, 1517500800, NOW:1513386624
Thursday, February 1, 10:00 AM
4112376
1517499000, 1517501700, NOW:1513386624
Thursday, February 1, 10:30 AM
4112376
1517499000, 1517501700, NOW:1513386624
Thursday, February 1, 10:30 AM
4132176
1517518800, 1517522400, NOW:1513386624
Thursday, February 1, 4:00 PM
4141176
1517527800, 1517535000, NOW:1513386624
Thursday, February 1, 6:30 PM
4200576
1517587200, 1517590800, NOW:1513386624
Friday, February 2, 11:00 AM
4225776
1517612400, 1517626800, NOW:1513386624
Friday, February 2, 6:00 PM
4283376
1517670000, 1517672700, NOW:1513386624
Saturday, February 3, 10:00 AM
4290576
1517677200, 1517680800, NOW:1513386624
Saturday, February 3, 12:00 PM
4297776
1517684400, 1517688000, NOW:1513386624
Saturday, February 3, 2:00 PM
4297776
1517684400, 1517688000, NOW:1513386624
Saturday, February 3, 2:00 PM
4454376
1517841000, 1517842800, NOW:1513386624
Monday, February 5, 9:30 AM
4456176
1517842800, 1517846400, NOW:1513386624
Monday, February 5, 10:00 AM
4461576
1517848200, 1517850000, NOW:1513386624
Monday, February 5, 11:30 AM
4463376
1517850000, 1517853600, NOW:1513386624
Monday, February 5, 12:00 PM
4477776
1517864400, 1517868000, NOW:1513386624
Monday, February 5, 4:00 PM
4481376
1517868000, 1517873400, NOW:1513386624
Monday, February 5, 5:00 PM
4486776
1517873400, 1517877000, NOW:1513386624
Monday, February 5, 6:30 PM
4488576
1517875200, 1517881500, NOW:1513386624
Monday, February 5, 7:00 PM
4488576
1517875200, 1517877900, NOW:1513386624
Monday, February 5, 7:00 PM
4542576
1517929200, 1517932800, NOW:1513386624
Tuesday, February 6, 10:00 AM
4542576
1517929200, 1517931900, NOW:1513386624
Tuesday, February 6, 10:00 AM
4542576
1517929200, 1517943600, NOW:1513386624
Tuesday, February 6, 10:00 AM
4546176
1517932800, 1517936400, NOW:1513386624
Tuesday, February 6, 11:00 AM
4546176
1517932800, 1517935500, NOW:1513386624
Tuesday, February 6, 11:00 AM
4564176
1517950800, 1517954400, NOW:1513386624
Tuesday, February 6, 4:00 PM
4573176
1517959800, 1517965200, NOW:1513386624
Tuesday, February 6, 6:30 PM
4574976
1517961600, 1517965200, NOW:1513386624
Tuesday, February 6, 7:00 PM
4627176
1518013800, 1518016500, NOW:1513386624
Wednesday, February 7, 9:30 AM
4628976
1518015600, 1518019200, NOW:1513386624
Wednesday, February 7, 10:00 AM
4628976
1518015600, 1518017400, NOW:1513386624
Wednesday, February 7, 10:00 AM
4632576
1518019200, 1518021000, NOW:1513386624
Wednesday, February 7, 11:00 AM
4632576
1518019200, 1518021900, NOW:1513386624
Wednesday, February 7, 11:00 AM
4643376
1518030000, 1518033600, NOW:1513386624
Wednesday, February 7, 2:00 PM
4650576
1518037200, 1518040800, NOW:1513386624
Wednesday, February 7, 4:00 PM
4650576
1518037200, 1518040800, NOW:1513386624
Wednesday, February 7, 4:00 PM
4713576
1518100200, 1518102900, NOW:1513386624
Thursday, February 8, 9:30 AM
4713576
1518100200, 1518102000, NOW:1513386624
Thursday, February 8, 9:30 AM
4715376
1518102000, 1518105600, NOW:1513386624
Thursday, February 8, 10:00 AM
4717176
1518103800, 1518106500, NOW:1513386624
Thursday, February 8, 10:30 AM
4717176
1518103800, 1518106500, NOW:1513386624
Thursday, February 8, 10:30 AM
4733376
1518120000, 1518127200, NOW:1513386624
Thursday, February 8, 3:00 PM
4736976
1518123600, 1518127200, NOW:1513386624
Thursday, February 8, 4:00 PM
4736976
1518123600, 1518127200, NOW:1513386624
Thursday, February 8, 4:00 PM
4826976
1518213600, 1518195600, NOW:1513386624
Friday, February 9, 5:00 PM
4826976
1518213600, 1518220800, NOW:1513386624
Friday, February 9, 5:00 PM
4834176
1518220800, 1518224400, NOW:1513386624
Friday, February 9, 7:00 PM
4888176
1518274800, 1518282000, NOW:1513386624
Saturday, February 10, 10:00 AM
4888176
1518274800, 1518277500, NOW:1513386624
Saturday, February 10, 10:00 AM
4902576
1518289200, 1518292800, NOW:1513386624
Saturday, February 10, 2:00 PM
4906176
1518292800, 1518296400, NOW:1513386624
Saturday, February 10, 3:00 PM
5059176
1518445800, 1518447600, NOW:1513386624
Monday, February 12, 9:30 AM
5060976
1518447600, 1518451200, NOW:1513386624
Monday, February 12, 10:00 AM
5066376
1518453000, 1518454800, NOW:1513386624
Monday, February 12, 11:30 AM
5082576
1518469200, 1518472800, NOW:1513386624
Monday, February 12, 4:00 PM
5086176
1518472800, 1518480000, NOW:1513386624
Monday, February 12, 5:00 PM
5091576
1518478200, 1518483600, NOW:1513386624
Monday, February 12, 6:30 PM
5093376
1518480000, 1518482700, NOW:1513386624
Monday, February 12, 7:00 PM
5147376
1518534000, 1518537600, NOW:1513386624
Tuesday, February 13, 10:00 AM
5147376
1518534000, 1518537600, NOW:1513386624
Tuesday, February 13, 10:00 AM
5147376
1518534000, 1518548400, NOW:1513386624
Tuesday, February 13, 10:00 AM
5147376
1518534000, 1518536700, NOW:1513386624
Tuesday, February 13, 10:00 AM
5150976
1518537600, 1518541200, NOW:1513386624
Tuesday, February 13, 11:00 AM
5150976
1518537600, 1518540300, NOW:1513386624
Tuesday, February 13, 11:00 AM
5168976
1518555600, 1518559200, NOW:1513386624
Tuesday, February 13, 4:00 PM

View All Programs

select *, date_format(date, '%M %e'), date_format(date, '%W'), events.id as eventid , unix_timestamp( concat(date, ' ', if(ampm = 'AM', if(hour = 12, 0, hour), if(hour = 12, hour, hour + 12)), ':', minutes) ) as utime, unix_timestamp( concat(date, ' ', if(ampmend = 'AM', if(hourend = 12, 0, hourend), if(hourend = 12, hourend, hourend + 12)), ':', minutesend) ) as utimeend from events,locations where events.location = locations.id and category != '7' and category != '8' and category != '11' and events.location != '' and active = 'Y' and deleted = 'N' and to_days(date) >= to_days(now()) and to_days(date) <= (to_days(now()) + 60) order by utime

New at CCPL