如何从今天起得到30天前的日期

如何在 SQL 中获得今天之前的30天。

275286 次浏览

小开

最佳答案

T-SQL

declare @thirtydaysago datetime
declare @now datetime
set @now = getdate()
set @thirtydaysago = dateadd(day,-30,@now)


select @now, @thirtydaysago

or more simply

select dateadd(day, -30, getdate())

MYSQL

SELECT DATE_ADD(NOW(), INTERVAL -30 DAY)

小开

In MS SQL Server, it is:

SELECT getdate() - 30;

小开

SELECT (column name) FROM (table name) WHERE (column name) < DATEADD(Day,-30,GETDATE());

Example.

SELECT `name`, `phone`, `product` FROM `tbmMember` WHERE `dateofServicw` < (Day,-30,GETDATE());

小开

Try adding this to your where clause:

dateadd(day, -30, getdate())