淘淘小窝

一个简单的hqlselect new map(date1 as date1) from tabel问题数据库中date1字段改成date类型 报错,如果是datetime就无错误分析java.util.Date中包含时分秒,java.sql.Date中不包含时分秒修改Date类型

使用sql case   when 统计SELECT XiaoQu ,count(1) errorTotal,sum(CASE WHEN ErrorState='new' THEN 1 ELSE 0 end) AS newError,sum(CASE WHEN ErrorState='finish' THEN 1 ELSE 0 end) AS finish,sum(CASE WHEN Er

--查询当天：   select * from info where DateDiff(dd,datetime,getdate())=0     --查询24小时内的:   select * from info where DateDiff(hh,datetime,getDate())--本月记录   SELECT * FROM 表 WHERE da

本周数据从周一开始SELECT    *FROM    `tend_scheduling_item`WHERE    tend_psn_hid = 498AND YEARWEEK(date_format(duty_date, '%Y-%m-%d'),1) = YEARWEEK(now(),7);本周数据从周日kai'开始SELECT    *FROM    `ten...

//清空idalter table yc_cur drop id;//重新生成alter table yc_cur add id int not null primary key auto_increment first;