Monday, May 2, 2016

MSSQL - SELECT DATE BETWEEN

SELECT [Code_no]
      ,[User_RefNo]
      ,[Loan_No]
      ,[Created_Date]
      ,[Created_By]
      ,[Tax]
FROM [DB_name].[dbo].[Table_name]
WHERE [Created_Date] BETWEEN '2016-04-18' AND '2016-04-20 23:59:59.999'
ORDER BY [Created_Date] asc

No comments:

Post a Comment