time_to_sec函数的使用

sql中time_to_sec函数的用法（时分秒等进行分类查询）

 1. 按小时进行查询

SELECT
	* 
FROM
	mydata_dizhenju_power 
WHERE
	time_to_sec( Observetime ) % 3600 = 0 
	) a 
WHERE
	a.Observetime BETWEEN #{formatStart}
	
	AND #{formatEnd}
	

 2. List item

按分钟
SELECT
	* 
FROM
	$ { dbname } 
WHERE
	time_to_sec( Observetime ) % 60 = 0 BETWEEN #{formatStart} and  #{formatEnd}
	

3.  按天数
SELECT
	* 
FROM
	$ { dbname } 
WHERE
	time_to_sec( Observetime ) % 86400 = 0 BETWEEN #{formatStart} and  #{formatEnd}