Need script to list records that were updated on a given date

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Greg Charles SSC-Forever Points: 45403 More actions · Answer 1

select * from table

where DBDate between '01/28/2005' and '01/29/2005'

You just have to remember that '01/28/2005' really means '01/28/2005 00:00:00.000' when compared to a datetime.

Greg

RML51 SSCarpal Tunnel Points: 4410 More actions · Answer 2

Thanks Greg. I tried that, but it doesn't work.

select * from table

where DBDate between '01/28/2005' and '01/29/2005'

Doesn't return any records.

If I change it to:

select * from table

where DBDate between '01/27/2005' and '01/29/2005'

I only get records for 1/27/2005.

Greg Charles SSC-Forever Points: 45403 More actions · Answer 3

Looks like it's working to me. Maybe there aren't any rows with a DBDate of 1/28/2005.

Try the select where DBDate > '01/27/2005' and see what you get.

Greg

RML51 SSCarpal Tunnel Points: 4410 More actions · Answer 4

My bad. You're right, the first script is best. My test db was restored from last night's backup after today's updates were applied.

Thanks