Help filtering down to date RRS feed

  • General discussion

  • Hi all, 

    I have a Query that I need to select down to the date and I cant figure out a where statement to pull to a yyyy-mm-dd format. 

    Currently the modified date time is set to the milisecond - 2018-12-12 22:04:53.030. 

    I would like to only return fields from the day prior. 

    /****** Script for SelectTopNRows command from SSMS  ******/
      FROM [PR_PS3_Report].[bu].[vw_SchedulePublishedChanges] as a
      Inner join [PR_PS3_Report].[bu].[vw_Staff] as b on a.ModifiedStaffNum = b.StaffNum

    Wednesday, October 28, 2020 10:41 PM

All replies

  • Hello Hitesh,

    This forum is dedicated to supporting issues related to open specification. You can access open specifications at Your inquiry does not seem to be related to open specifications.

    For a better chance of getting an answer to your question, you may want to post your question to the following forum:

    Sreekanth Nadendla
    Microsoft Windows Open Specifications
    Thursday, October 29, 2020 3:42 PM
    Sunday, November 1, 2020 10:46 AM