SQL ' Dates

[Cullen411]

Both these SQL statements work one has the ' as delimiters, which one has the right syntax?

SELECT * FROM tblTable WHERE GETDATE() - DATETIMESTARTED <iDays

SELECT * FROM tblTable WHERE GETDATE() - 'DATETIMESTARTED' <iDays

thanks.

 

[vongrunt]

If DATETIMESTARTED is column from tblTable - first one.

If DATETIMESTARTED is date constant - second one.

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[Cullen411]

Ok it's a column value so it's the first one.
Any reason why this is the case?