如何在sql server中获取最近5天的数据

问题描述

我希望按照选定的日期获取5天的数据，为此我写了一个存储过程但它无法正常工作，请帮助我

I Want to get data of 5 days by selected date, for this i wrote a stored procedure but its not working, Please help me

ALTER PROCEDURE dbo.UserDairy
    @pToDate    datetime
AS
    SELECT * FROM tbl_UserDetail
    WHERE UDate BETWEEN @pToDate AND DATEADD(day, -5, @pToDate)
        ORDER BY UserID DESC
    RETURN

这里UDate是创建日期和@pToDate参数

here UDate is created date and @pToDate parameter

推荐答案

这篇关于如何在sql server中获取最近5天的数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！