GETDATE -1 or 2

sql sql-server tsql getdate
user2646056 picture user2646056 · Aug 2, 2013 · Viewed 28.6k times · Source

With this:

CONVERT(varchar(10),DATEADD(month,1,GETDATE()),120)

I get this

2013-08-19

which is perfect but I need it to output one or two days less

example: 2013-08-18

Any tips?

Answer

Rccompton picture Rccompton · Aug 2, 2013

For 1 day less you could use

Select CONVERT(varchar(10),(dateadd(dd, -1, getdate())),120)

or for 2 days difference use 

Select CONVERT(varchar(10),(dateadd(dd, -2, getdate())),120)

The convert will make it the format you seek and the dateadd will change the dd or day with -1 or 2 whichever you are wanting to use at that time.

Related questions

Convert getdate() to EST

I would like to convert getdate() in SQL Server to EST time.

Read More
How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More
How do I perform an IF...THEN in an SQL SELECT?

How do I perform an IF...THEN in an SQL SELECT statement? For example: SELECT IF(Obsolete = 'N' OR InStock = 'Y' ? 1 : 0) AS Saleable, * FROM Product

Read More