我想查出 开始日期(event_start_time)或 结束日期(event_end_time)在 2015-11的所有数据
这个 where 语句要怎么写?
回复讨论(解决方案)
.... where data_format(event_start_time, '%Y-%m') = '2015-11' or data_format(event_end_time, '%Y-%m') = '2015-11'
.... where data_format(event_start_time, '%Y-%m') = '2015-11' or data_format(event_end_time, '%Y-%m') = '2015-11'
data_format does not exist