sql - SQL 'BETWEEN' 语法不正确

Question

我正在尝试运行一个简单的查询。

  SELECT power_output.*
  FROM power_output
  WHERE t_stamp BETWEEN '{StartDate}'
  AND t_stamp '{EndDate}'

我收到以下错误:

Incorrect syntax near 'Mon Jan 11 00:00:00 EST 2016'

我希望它返回“mm/dd/yyyy”

Answer 1

正确的语法是:

 SELECT power_output.*
 FROM power_output
 WHERE t_stamp BETWEEN '{StartDate}' AND '{EndDate}'

列仅在查看 BETWEEN 时声明一次