Sql Statement Not Working - "Operand Type Clash: Date Is Incompatible with Int'
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...
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.
3 Answers
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')
(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.
Use this
SELECT Date, Time, Production
FROM Products
WHERE Date="2008-09-07"
Date must be in yyyy-mm-dd format
Maya is a hardware enthusiast who tests and reviews smart home devices, smartphones, wearables, and audio gear. She focuses on practical consumer value and build quality.
