query = SELECT event_title, event_place, event_info, event_pic,
DATE_FORMAT(event_date, '%e') AS event_day,
DATE_FORMAT(event_date, '%d/%m/%Y') AS event_monthDay,
DATE_FORMAT(event_date, '%H:%i') AS event_hour
FROM eventsTable
WHERE
DATE_FORMAT(event_date, '%c') = 2 AND
DATE_FORMAT(event_date, '%Y') = 2012
ORDER BY event_date ASC
|
|
|
|
|
|
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
11 |
| 12 |
13 |
14 |
15 |
16 |
17 |
18 |
| 19 |
20 |
21 |
22 |
23 |
24 |
25 |
| 26 |
27 |
28 |
|
|
|
|
שעות ותאריכי המופעים עלולים להשתנות, והם באחריות האמן/אולם בלבד.
|