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)

Still have questions? We can help. Submit a case to Technical Support.

Last Modified On: January 12, 2021