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.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Dumb Date Error Argh..

Author  Topic  jhilb Starting Member 22 Posts Posted - 2001-04-06 : 10:24:19 I execute this: DECLARE @QWE as datetime DECLARE @ASD as datetime set @QWE = convert(datetime,"06/14/2001",101) set @ASD = convert(datetime,"06/15/2001",101) select * from users I get this: Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name '06/14/2001'. If I change the single quotes to double quote I get a different error. If I comment those out, it works. That query looks good to me?