Convert date to YYYYMM format

by 
SELECT CONVERT(nvarchar(6), GETDATE(), 112)

More Related Contents:

  1. Convert text to system date format [duplicate]
  2. How to get a particular preceding value of a column in SQL [closed]
  3. SQL where clause odd behavior [closed]
  4. How do I obtain a Query Execution Plan in SQL Server?
  5. How do I escape a single quote in SQL Server?
  6. Simple way to transpose columns and rows in SQL?
  7. What is the meaning of the prefix N in T-SQL statements and when should I use it?
  8. Only inserting a row if it’s not already there
  9. Unpivot with column name
  10. Selecting data from two different servers in SQL Server
  11. SQL JOIN vs IN performance?
  12. Most efficient way in SQL Server to get date from date+time?
  13. TSQL Pivot without aggregate function
  14. How to generate a range of dates in SQL Server
  15. SQL RANK() versus ROW_NUMBER()
  16. Generate SQL Create Scripts for existing tables with Query
  17. How to rewrite IS DISTINCT FROM and IS NOT DISTINCT FROM in SQL Server 20008R2?
  18. How do I delete from multiple tables using INNER JOIN in SQL server
  19. Check if a row exists, otherwise insert
  20. SQL : BETWEEN vs =
  21. How do I perform a GROUP BY on an aliased column in SQL Server?
  22. How do I make a composite key with SQL Server Management Studio?
  23. Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)
  24. CTE error: “Types don’t match between the anchor and the recursive part”
  25. TransactSQL to run another TransactSQL script
  26. How do I remove extended ASCII characters from a string in T-SQL?
  27. Getting Dates between a range of dates
  28. The most elegant way to generate permutations in SQL server
  29. Convert bigint to datetime
  30. When to use EXCEPT as opposed to NOT EXISTS in Transact SQL?

Leave a Comment