Convert month name to month number in SQL Server

by

How about this?

select DATEPART(MM,'january 01 2011') -- returns 1
select DATEPART(MM,'march 01 2011')  -- returns 3
select DATEPART(MM,'august 01 2011') -- returns 8

More Related Contents:

  1. About SQL Server IF clause [closed]
  2. SQL Server, How to set auto increment after creating a table without data loss?
  3. When should I use a table variable vs temporary table in sql server?
  4. How can I determine installed SQL Server instances and their versions?
  5. Datatype for storing ip address in SQL Server
  6. Add IIS 7 AppPool Identities as SQL Server Logons
  7. SQL Server: Query fast, but slow from procedure
  8. Errors: “INSERT EXEC statement cannot be nested.” and “Cannot use the ROLLBACK statement within an INSERT-EXEC statement.” How to solve this?
  9. Is there a way to loop through a table variable in TSQL without using a cursor?
  10. sql server invalid object name – but tables are listed in SSMS tables list
  11. How to get a date in YYYY-MM-DD format from a TSQL datetime field?
  12. How do I format a number with commas in T-SQL?
  13. What columns generally make good indexes?
  14. What is a free tool to compare two SQL Server Databases? [closed]
  15. SQL Server Management Studio alternatives to browse/edit tables and run queries [closed]
  16. SQL Server: Database stuck in “Restoring” state
  17. SQL server schema and default schema
  18. SQL Server ON DELETE Trigger
  19. SQL to find first non-numeric character in a string
  20. How to decrypt a password from SQL server?
  21. FOR XML PATH(”): Escaping “special” characters
  22. Unable to login to SQL Server + SQL Server Authentication + Error: 18456
  23. Convert a string with ‘YYYYMMDDHHMMSS’ format to datetime
  24. What are the advantages of VistaDB
  25. How to pivot unknown number of columns & no aggregate in SQL Server?
  26. Create Stored Procedures using Entity Framework Code First?
  27. “If not exists” fails on SQL CE
  28. Incorrect syntax near ‘)’ calling stored procedure with GETDATE
  29. Generate MD5 hash string with T-SQL
  30. Why can’t Entity Framework see my Stored Procedure’s column information?

Leave a Comment