FROM_UNIXTIME:日期格式转换函数
CONVERT ( event_time / 1000, signed ):时间戳去除后三位,signed转换为整数
SELECT
count( 1 ),
'year' AS flag
FROM
event_business
WHERE
FROM_UNIXTIME( CONVERT ( event_time / 1000, signed ), '%Y' ) = date_format( now( ), '%Y' )
FROM_UNIXTIME:日期格式转换函数
CONVERT ( event_time / 1000, signed ):时间戳去除后三位,signed转换为整数
SELECT
count( 1 ),
'year' AS flag
FROM
event_business
WHERE
FROM_UNIXTIME( CONVERT ( event_time / 1000, signed ), '%Y' ) = date_format( now( ), '%Y' )