SELECT ltrim(datepart(hh,Date)) FROM xxxx_tb WHERE ltrim(datepart(hh,Date))=17查询xxxx表里小时为17时的数据
今天0-1的SELECT AAAA, BBBB, Date FROM XXXX_tb WHERE convert(varchar(10),Date,120)=convert(varchar(10),getdate(),120) AND ltrim(datepart(hh,Date))BETWEEN 0 AND 1
SELECT SUM(值) FROM 表名 WHERE CONVERT(DATE,时间列) = CONVERT(date, GETDATE()) and DATEPART(HH,时间列) = 0
SELECT
ltrim(datepart(hh,Date))
FROM
xxxx_tb WHERE ltrim(datepart(hh,Date))=17查询xxxx表里小时为17时的数据
AAAA,
BBBB,
Date
FROM
XXXX_tb WHERE convert(varchar(10),Date,120)=convert(varchar(10),getdate(),120)
AND ltrim(datepart(hh,Date))BETWEEN 0 AND 1
SELECT SUM(值)
FROM 表名
WHERE CONVERT(DATE,时间列) = CONVERT(date, GETDATE()) and DATEPART(HH,时间列) = 0