Time Difference

• KGC

  Old Hand

  Points: 374

  More actions

  February 27, 2006 at 7:23 am

  #93651

  Hello to all.

  I want to create a script to find all PurchaseOrders (from a PO Table) between @yesterday at 15:00 and @today at 08:00.

  How can I create this?

  SELECT PONum

  FROM PO

  WHERE

  (POStatusDate > CONVERT(DATETIME, '@yestrday 15:00:00', 102)) AND (POStatusDate < CONVERT(DATETIME, '@today 08:00:00', 102))
  BR,
  Konstantinos

• SQLZ

  SSChampion

  Points: 12872

  More actions

  February 27, 2006 at 8:26 am

  #623473

  Hi,

  Try this:

  declare @yesterday datetime

  declare @today datetime

  set @yesterday = convert(datetime,convert(varchar(11),dateadd(dd,-1,getdate()),106) + ' 15:00:00.000')

  set @today = convert(datetime,convert(varchar(11),getdate(),106) + ' 08:00:00.000')

  SELECT PONum

  FROM PO

  WHERE

  POStatusDate > @yesterday AND POStatusDate < @today

  Hope that helps,

  Karl
  source control for SQL Server