Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lkanitz
Starting Member
2 Posts |
 Posted - 2011-12-19 : 14:53:33
|
| Here is my query:"SELECT robotname, objectkey, catalog_name, product_name, OEM_number, paragraph_desc, skuFROM productWHERE lastupdated > Date_Sub(curdate(), INTERVAL 1 DAY) and lastupdated < curdate()ORDER BY robotname"------------------------------------------------------------------when I try to execute the SQL it gives me this error:Syntax error: Encountered "1" at line 3, column 50.------------------------------------------------------------------Is it telling me that I can not have a 1 there? If so, then how do I signify the date? Is it my logic? please help. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
lkanitz
Starting Member
2 Posts |
Posted - 2011-12-19 : 15:08:21
|
| Ok, my apologies. Thanks for the direction. |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
not sure why this doesn't work.....