SQL 时间格式化

select 
			ID,
			MONITOR_EVENT_ID,
			MONITOR_EVENT_ITEM_ID,
			MONITOR_EVENT_ITEM_NAME,
			date_format(EVENT_CREATE_TIME,'%Y-%m-%d %T') as CREATE_TIME,
			date_format(EVENT_CREATE_TIME,'%Y-%m-%d') as DAY,
			date_format(EVENT_CREATE_TIME,'%T') as TIME,
			FIGURE,
			UNIT,
			IPPORT,
			EVENT_CREATE_TIME as EVENT_CREATE_TIME
		from
			monitor_data_event