MYSQL，DATETIME，事件，按月/年按SQL或输出分组？
|
我有一个带有
start_date
SELECT Event.id, Event.name, Event.start_date, Event.end_date,
EXTRACT(MONTH FROM `Event`.`start_date`) AS `event_month`,
EXTRACT(YEAR FROM `Event`.`start_date`) AS `event_year`
FROM `my_events` AS `Event`
$events
Array
(
[0] => Array
(
[Event] => Array
(
[id] => 1
[name] => Event Name One
[start_date] => 2011-07-03 11:00:00
[end_date] => 2011-07-03 16:00:00
)
[0] => Array
(
[event_month] => 7 // This event occurs in July
[event_year] => 2011
)
)
[1] => Array
(
[Event] => Array
(
[id] => 2
[name] => Event Name Two
[start_date] => 2011-07-09 11:00:00
[end_date] => 2011-07-09 15:00:00
)
[0] => Array
(
[event_month] => 7 // this event occurs in July
[event_year] => 2011
)
)
[2] => Array
(
[Event] => Array
(
[id] => 3
[name] => Event Name Three
[start_date] => 2011-07-09 11:00:00
[end_date] => 2011-07-09 15:00:00
)
[0] => Array
(
[event_month] => 8 // this event occurs in august.
[event_year] => 2011
)
)
EXTRACT
array_merge
$result = array_merge($event)
没有找到相关结果
已邀请:
2 个回复
炬卤遁蝎变
脖呐
和或函数，但我认为您不需要而是：SELECT YEAR( Event.start_date ) AS event_year , MONTH( Event.start_date ) AS event_month , MONTHNAME( Event.start_date ) AS event_month_name , Event.id , Event.name , Event.start_date, , Event.end_date FROM my_events AS Event WHERE Event.start_date >= \'2011-07-01\' AND Event.start_date < \'2013-01-01\' ORDER BY Event.start_date ASC和来添加July，August ...和2011标签。