如题,例如根据时间"2012-03-19 17:10:55.883",要获取两个时间"2012-03-19 17:00:00.00"和"2012-03-19 17:59:59.999"。如何获取?
------解决方案--------------------
- SQL code
select convert(varchar(14),'2012-03-19 17:10:55.883',120)+'00:00.000',convert(varchar(14),'2012-03-19 17:10:55.883',120)+'59:59.999'/*(无列名) (无列名)2012-03-19 17:00:00.000 2012-03-19 17:59:59.999*/