新增文章

文章标题分类内容

SELECT * FROM (
------------------------------------------------------------------------------------------------------------------------------------------
   SELECT

FIvDate  FIvDate2

,isnull(convert(nvarchar(20) ,FIvDate ,23),'')  FIvDate  -- 日期空值 参与 条件判断

,isnull(FIvNo ,'')  FIvNo  -- 文本空值 参与 条件判断

,isnull(FIvSeq ,0)  FIvSeq  -- 数字空值 参与 条件判断

FROM TMPB3766E7A0B7111EFACB10050563 
------------------------------------------------------------------------------------------------------------------------------------------
   ) a1

WHERE (FIvDate>={ts'2024-02-29 00:00:00'} and FIvDate<={ts'2024-02-29 23:59:59'})  -- 等于  2024-02-29

AND  (FIvDate>={ts'2024-05-06 00:00:00'} and FIvDate<{ts'2024-05-07 00:00:00'})   -- 今天  2024-05-06
    AND  (FIvDate>={ts'2024-05-05 00:00:00'} and FIvDate<{ts'2024-05-06 00:00:00'})   -- 昨天  2024-05-05
    AND  (FIvDate>={ts'2024-05-07 00:00:00'} and FIvDate<{ts'2024-05-08 00:00:00'})   -- 明天  2024-05-07
    AND  (FIvDate>={ts'2024-04-28 00:00:00'} and FIvDate<{ts'2024-05-05 00:00:00'})   -- 上周  2024-04-28 至 2024-05-04

AND  (FIvDate>={ts'2024-05-01 00:00:00'} and FIvDate<={ts'2024-05-31 23:59:59'})  -- 月    2024-05