Home Forums SQL Server 2005 Administering Need script to list records that were updated on a given date RE: Need script to list records that were updated on a given date
Greg Charles
SSC-Forever
Points: 45403
More actions
January 28, 2005 at 9:48 am
#539562
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