Get previous month in SQL when given a varchar

by

Try this:

DECLARE @dt VARCHAR(8) = '201501'

SELECT LEFT(CONVERT(VARCHAR(8), DATEADD(m, -1, @dt + '01'), 112), 6)

Output:

201412

Using DATEADD you can calculate the previous month. This function conveniently accepts a string as an argument. CONVERT is then used to convert the result back to yyyymmdd format.

More Related Contents:

  1. How to create a specific SQL Server stored procedure? [closed]
  2. Inserting multiple rows in a single SQL query? [duplicate]
  3. Passing a varchar full of comma delimited values to a SQL Server IN function
  4. SQL update query using joins
  5. Difference between numeric, float and decimal in SQL Server
  6. How to combine date from one field with time from another field – MS SQL Server
  7. T-SQL: Deleting all duplicate rows but keeping one [duplicate]
  8. SQL: IF clause within WHERE clause
  9. “CASE” statement within “WHERE” clause in SQL Server 2008
  10. SQL Server – How to lock a table until a stored procedure finishes
  11. Where value in column containing comma delimited values
  12. How to use table variable in a dynamic sql statement?
  13. How to create a unique index on a NULL column?
  14. Search text in stored procedure in SQL Server
  15. What happens to an uncommitted transaction when the connection is closed?
  16. Create Trigger to log SQL that affected table?
  17. Difference between datetime and timestamp in sqlserver? [duplicate]
  18. Sequence vs identity
  19. Cannot use UPDATE with OUTPUT clause when a trigger is on the table
  20. SQL grouping by month and year
  21. “IN” clause limitation in Sql Server
  22. Meaning of square brackets [] in MS-SQL table designer? [duplicate]
  23. Reference an alias elsewhere in the SELECT list
  24. Selecting first row per group
  25. How do I specify date literal when writing SQL query from SQL Server that is linked to Oracle?
  26. SQL Server Convert integer to binary string
  27. How to find column names for all tables in all databases in SQL Server
  28. SQL Row_Number() function in Where Clause
  29. SQL update trigger only when column is modified
  30. Passing dynamic order by in stored procedure

Leave a Comment