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

  • 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

    Greg