mybatis的日期格式

select id,name,operation,DATE_FORMAT(addTime,"%Y-%m-%d %H:%i:%s") addTime from log
		where 1=1
		
			and name LIKE concat('%',#{name},'%' ) 
		
		  
		
			and DATE_FORMAT(addTime,"%Y-%m-%d")>=beg 
		
		
			and DATE_FORMAT(addTime,"%Y-%m-%d")<=end

 

版权声明：本文为qq19566原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。