Tìm kiếm ngày có sử dụng giờ trong SQL Server

• Tạo PROCEDURE trong SQL Server
• Mở tài khoản sa trong SQL Server

-- SQL Server Where Time and Date  --> Not Found Record ??

Select * From tbBanHang Where Day(DateCreate)=5 And Month(DateCreate)=4 And Year(DateCreate) =2023
-- Year =2023
-- Month=4
-- Day =5

Select * From tbBanHang Where DateCreate Between '2023-4-5' AND '2023-4-5'

-- Fix SQL SQL Server Where Time and Date  --> Not Found Record
Select * From tbBanHang Where DateCreate Between '2023-4-5 0:0' AND '2023-4-5 23:59'

-- Begin Day:  Hour =0 , minite: 0
-- End Day: Hour = 23 , minute: 59

--- OK

 Xem video fix SQL Server Where Time and Date

https://www.youtube.com/watch?v=zTSWj69K4gQ

 

---- ví dụ 2

 

Select
        Sum(TongCongTien) as TongTienHang_HomNay
    From dbo.tbBanHang
    Where
        DateCreate Between
            (convert(varchar, getdate()  , 23) + ' 0:0'  )
            AND
            (convert(varchar, getdate()  , 23) + ' 23:59'  )
    AND TinhTrang=1

 

-- ví dụ 3: add date

 SELECT DATEADD(year, 1, '2017/08/25') AS DateAdd;

 SELECT DATEADD(year, 1, convert(varchar, getdate() )  ) AS DateAdd;