如何在SQL Server中从当前日期时间获取最近7天的数据到最近7天 [英] How to get last 7 days data from current datetime to last 7 days in sql server

问题描述

我正在使用pentaho将表A数据从sql server加载到mysql 当加载数据时，我只需要从sql server A表中获取最近7天的数据到mysql 在sql server中，createdate列的数据类型类似于datetime AND 在mysql created_on列中，数据类型为时间戳

Hi I am loading table A data from sql server to mysql using pentaho when loading data i need to get only last 7 days data from sql server A table to mysql In sql server createddate column data type is like datetime AND In mysql created_on column datatype is timestamp

在这里我使用下面的查询，但是我只获得5天的数据
请帮助我解决这个问题

Here I used below query but i am getting only 5 days data
Please help me in this issue

select id,    
NewsHeadline as news_headline,    
NewsText as news_text,    
state,    
CreatedDate as created_on      
from News    
WHERE CreatedDate BETWEEN GETDATE()-7 AND GETDATE()
order by createddate DESC

推荐答案

尝试类似的方法:

 SELECT id, NewsHeadline as news_headline, NewsText as news_text, state CreatedDate as created_on
 FROM News 
 WHERE CreatedDate >= DATEADD(day,-7, GETDATE())

这篇关于如何在SQL Server中从当前日期时间获取最近7天的数据到最近7天的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！