need a timestamp in below query. anyone can help me.
SELECT City, Location ,StatusLED,SP1,SP2,Caption FROM [dbo].[Nodes]
WHERE Status = '2' and ( SP1 in ( 'x', 'x', 'x', x', 'x','x')
OR SP2 in ( 'x', 'x', 'x', x', 'x','x'))
and ( CITY in ('x', 'x', 'x', 'x', 'x', 'x')
OR Location in (x', 'x', 'x', x', 'x','x') )