I am drawing a blank on how to do this:
select * from InvoiceInfo
where InvoiceDateTime = '2015-07-01'
The Invoicedatetime column is datetime and I only want to compare against a date. This is on MS SQL 2012
Asked
Active
Viewed 37 times
0
Silvia Doomra
- 947
- 8
- 16
JeffreyLazo
- 813
- 4
- 13
- 17
-
in your where you need CAST('2015-07-01' AS DATETIME) – Maxqueue Jul 01 '15 at 19:31
-
There are several ways - some better than others: 1. Convert to `date`, 2. String comparison, 3. `>= '2015-07-01' AND < '2015-07-02'` – D Stanley Jul 01 '15 at 19:33
-
So using one of the methods in the linked answer, your `WHERE` looks like `WHERE cast(InvoiceDateTime as date) = '2015-07-01'` – Michael Berkowski Jul 01 '15 at 19:34