SQL Updated since last visit column

Question

I'm working with SQL Server and I'm pretty new to SQL in general, so if this is a very trivial question, please bear with me.

I have a table in a database with a datetime field representing some timestamp. When extracting the table via a SELECT statement, I would like to have a column of True/False representing whether or not the row has been updated since some given time.

I've tried something like:

"SELECT val1, val2, FORMAT(LastTimestamp > " + GivenTime + ", 'True/False')" +
"FROM table"

I've gotten something similar to work on the w3 online query tester, but I think that may be in MySQL and I was unable to test datetimes. The database right now seems to complain about the > symbol.

Anyone know the proper query string?

Answer 1

something like:

select val1, val2, 
case when LastTimestamp > '20100720' then 'True' else 'False' end as [True/False] 
from Table

Note that in the above I've used a date literal which breaks down into 'yyyymmdd'