Re: extract data from a table for the last 7 days

• sql_Reporter

  SSCrazy

  Points: 2329

  More actions

  March 9, 2006 at 6:52 am

  #365463

  Hi i've written this bit of code to extract data from a table for the last 7 days, i just like to know id this the best way of going this.

   

  select open_dt

  from dbo.tbl_metrics_grca_fl

  where open_dt >= convert(datetime,convert(char(8),getdate()-7,112))

   

  Thanks

   

• Phil Parkin

  SSC Guru

  Points: 246991

  More actions

  March 9, 2006 at 7:02 am

  #625658

  Here's another way that should run quicker.

  declare @then datetime

  set @then = DateAdd(Day, -7, getdate())

  select open_dt

  from dbo.tbl_metrics_grca_fl

  where open_dt >= @then

  The absence of evidence is not evidence of absence.
  Martin Rees

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel