如何在sql server中获取最近5天的数据 [英] How to Get data of last 5 days in sql server

问题描述

我希望按照选定的日期获取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 2005中选择从今天到最近5天的数据> [ ^ ]

Same solution-

How to select data from todays to last 5 days from the sql server 2005 >[^]

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