22,209
社区成员
发帖
与我相关
我的任务
分享
SELECT 字段列表....
FROM (
SELECT *,
CASE WHEN RIGHT(BEGIN_LOAD_TIME, 8) < '19:30:00' THEN LEFT(BEGIN_LOAD_TIME, 10)
ELSE LEFT( CONVERT(varchar(19),
dateadd([d], 1, CONVERT(datetime,BEGIN_LOAD_TIME)), 20)
,10)
END AS yyyyMMdd
FROM V_OUTPUT_HISTORY
) as Tmp
GROUP BY yyyyMMdd