Timestamp query for day 1

[Rob7412]

How would I query records that have a timestamp before 4:00pm today from a table

 

[Rob7412]

OOps I should have said I have a timestamp field called timecreated I need to query records that were created on todays date before 4:00pm

 

[SQLDenis]

where Value < DATEADD(hh,16,DATEADD(dd, DATEDIFF(dd, 0, GETDATE())+0, 0))

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[Rob7412]

Thanks SQLDenis

 

[SQLDenis]

No problem

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/