62,073
社区成员
发帖
与我相关
我的任务
分享
select * from tab order by CASE WHEN DATEPART(HH,[CREATEDDATE])BETWEEN DATEPART(HH,CAST(LEFT([TRADETIME],5)AS DATETIME ))
AND DATEPART(HH,CAST(RIGHT([TRADETIME],5)AS DATETIME ))
THEN convert(varchar(30),CREATEDDATE,120)+'0' ELSE convert(varchar(30),CREATEDDATE,120)+'1' END
---不知道是不是你想要的结果
/*
ID TRADETIME CREATEDDATE
------------------- ----------- ------------------------------------------------------
QGC0906292828222400 00:00-00:00 2009-06-29 18:07:54.440
QGC0906302505500808 00:00-00:00 2009-06-30 09:16:28.127
QGC0906303403865260 00:00-00:00 2009-06-30 09:17:57.963
QGC0906302883502262 23:00-05:00 2009-06-30 09:24:15.410
QGC0906300475566216 00:00-00:00 2009-06-30 09:27:24.113
QGC0906302079159966 20:00-04:00 2009-06-30 09:30:04.473
QGC0906303739973920 09:00-18:00 2009-06-30 09:40:00.067
QGC0906303902317670 00:00-00:00 2009-06-30 09:40:16.283
QGC0906304051380170 02:00-16:00 2009-06-30 09:40:31.190
(所影响的行数为 9 行)
*/