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)
Last Modified On:
No, open a new Support Case