Incorrect SQL 'BETWEEN' syntax

Question

I'm trying to run a simple query.

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

I'm getting the following error:

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

I'd like it to return 'mm/dd/yyyy'

Remove the second `t_stamp`. – Gordon Linoff Jan 11 '16 at 21:29 — Gordon Linoff, Jan 11 '16 at 21:29

score 3 · Answer 1 · answered Jan 11 '16 at 21:31

3

The correct syntax is:

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

Column is only declared once see BETWEEN

answered Jan 11 '16 at 21:31

connectedsoftware

Thank you for your response. I removed the second t_stamp and the error I get now is: Conversion failed when converting date and/or time from character string. – Jason Baldridge Jan 11 '16 at 22:47

score 2 · Answer 2 · answered Jan 11 '16 at 21:31

2

You don't need to specify the column after the between x and x.

This will work:

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

answered Jan 11 '16 at 21:31

Phiter

Thank you for you response. I removed the second t_stamp and the error I get now is: Conversion failed when converting date and/or time from character string. – Jason Baldridge Jan 11 '16 at 22:39
Try this http://stackoverflow.com/questions/14119133/conversion-failed-when-converting-date-and-or-time-from-character-string-while-i – Phiter Jan 11 '16 at 22:41

2 Answers2