Between Date Literals

Question

How do I make this work in SQL Server (2005)? The error message is 'Invalid column name' on the literals.

SELECT tstamp, GVEA_Load_Net_MWH 
  FROM DA.dbo.Oplog
 WHERE CAST(LEFT(tstamp,18) AS datetime) BETWEEN "01/01/2009 00:00:00" 
                                             AND "01/01/2010 00:00:00"

Answer 1

Change the double quotes to single.

Answer 2

Like this for your example

SELECT tstamp, GVEA_Load_Net_MWH FROM DA.dbo.Oplog
WHERE CAST(LEFT(tstamp,18) AS datetime) BETWEEN '20090101' AND '20100101'

Notice the ISO safe and language safe YYYYMMDD format? Keep in mind that this query is not SARGable and will not use an index

Also take a look How Does Between Work With Dates In SQL Server? to understand why between might sometimes not give you the results you epect