SQL statement not working - "Operand type clash: date is incompatible with int'
Solution 1
Your date format is incorrect, it needs to be in quotes and rearranged slightly.
WHERE (Date = 'Year-Month-day')
or rather
WHERE (Date = '2008-09-07')
Solution 2
(Date = 07 / 09 / 2008)
Here you dividing (int)7 by (int)9 and then by (int)2008. So 07 / 09 / 2008
is an integer result of some calculations.
In order to pass the date instead, you should put it into quotes.
Blob
Updated on June 26, 2022Comments
-
Blob almost 2 years
I have a table which i am trying to return the Time and Productno columns for a specific date. When i try the following SQL command it returns the error: "Operand type clash: date is incompatible with int'. I have research on forums and this is the way most people have been achieving a similar thing which is getting me puzzled. The data types for the following fields are as follows: Date: date. Time: time(7). Productno: int.
SELECT Date, Time, Productno FROM Products WHERE (Date = 07 / 09 / 2008)
Please could i be advised where i am going wrong?
Thanks.