mysql时间转换函数

效果：

-- 查看站投放量

SELECT province '投放省份',city '投放城市',place as '投放场所类型',count(id) as '使用频次' FROM sell_order 
GROUP BY place,province,city HAVING place LIKE '%站%'
ORDER BY count(id) DESC

-- 查看北京
SELECT id '编号',cust_name as '顾客名',create_time as '使用时间',province '投放省份',city '投放城市',place as '投放场所类型',place_sub_type as '详细场所' FROM sell_order WHERE province = '北京'


SELECT id '编号',cust_name as '合作客户',date_format(create_time,'%Y-%m-%d') as '使用时间',province '投放省份',city '投放城市',place as '投放场所类型',place_sub_type as '详细场所' FROM sell_order WHERE province = '北京'

时间函数参见链接：http://www.w3school.com.cn/sql/func_date_format.asp