SQL Criteria to Select Data from a DateTime or Date Field in Microsoft SQL Server

 

The following examples select data from a Microsoft SQL Server table using a DateTime or Date field range as the selection criteria:

Note: The start time is 1 second past midnight, and the end time is 1 second before midnight to cover the entire day.

• To select a single DateTime, use:

  select * from NameAddress where CreateDate >= '12/14/2019 00:00:01' and CreateDate <= '12/14/2019 23:59:59)

• To select multiple DateTimes, use:

  select * from NameAddress where CreateDate >= '12/1/2019 00:00:01' and CreateDate <= '12/14/2019 23:59:59)

• To select a single Date, use:

  select * from NameAddress where CreateDate >= '12/14/2019' and CreateDate <= '12/14/2019 23:59:59)

• To select multiple Dates, use:

  select * from NameAddress where CreateDate >= '12/1/2019' and CreateDate <= '12/14/2019)