Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

DateTime Query

2 Posts 1 Posters 0 Views 1 Watching

S Offline
S Offline
solutionsville

wrote on last edited by

#1

I want to query a table for the previous date. Not sure how to construct the WHERE statement. Thanks,
S 1 Reply Last reply

0
S solutionsville

I want to query a table for the previous date. Not sure how to construct the WHERE statement. Thanks,
S Offline
S Offline
solutionsville

wrote on last edited by

#2

The answer was; WHERE [TimeStamp]>= Convert(varchar(10), DateADD(DAY, -1, GETDATE()), 101) AND [TimeStamp] < Convert(varchar(10), GETDATE(), 101) This gave the info for the previous day only. Brian
1 Reply Last reply

0

Log in to reply