转换举例,请参考:
select
cast
(
'2016-2-20'
as
datetime)
select
cast
(
'2/20/2016'
as
datetime)
select
cast
(
'2016-2-20 11:22:33'
as
datetime)
select
cast
(
'2/20/2016 11:22:33.98'
as
datetime)
select
cast
(
'16-2-20'
as
datetime)
select
cast
(
'16-2-20 11:33:44'
as
datetime)
select
cast
(
'16/2/20'
as
datetime)
select
cast
(
'16/2/20 11:12:13:144'
as
datetime)
SELECT
YEAR (cast(snap_time as datetime)) `year`,
MONTH (cast(snap_time as datetime)) `month`,
COUNT (1) num
FROM
xy_ftp_upload
GROUP BY
YEAR (cast(snap_time as datetime)),
MONTH (cast(snap_time as datetime))
ORDER BY
YEAR (cast(snap_time as datetime)),
MONTH (cast(snap_time as datetime))
DESC