Query Data based on functions e.g GETDATE()

• fortunen

  SSC Enthusiast

  Points: 172

  More actions

  October 12, 2011 at 10:44 am

  #245195

  Hi Gurus

  I have a table that have a datetime column, I want to return data based on datetime on previous month.

  e.g

  SELECT a,b

  WHERE [date & time] >= ' 2011-09-03 00:00:00 AND [date & time] <= '2011-09-03 23:59:59'

  My problem is i want a function that will return the date and time as above based on GETDATE() function, I can work out the query to access the previous month by using DATEADD(M,-1,GETDATE()), but it also gives me the current time.

  Is the a way i can set my time to be fixed on both dates. We usually set the date & time in our software when running the report, but now i want to use ssis to extract & upload to a ftp server, instead of us running it manually.Or is the a way to do the above in SSRS??

  Thanks in Advanced

  Fortune (South Africa)

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  October 12, 2011 at 10:45 am

  #1393601

  SELECT DATEADD(D, 0, DATEDIFF(D, 0, GETDATE()))