Monday, May 21, 2007

SQL query to get Month Name for today

I wanted to insert the month name of the current date into a table using a SQL query.

I first thought that I could achieve this by simply using the monthname function. But when I typed that in the SQL Query analyser, the error made me realise that it is not that easy to get the result I want.

So in the end here is what I came up with:

select datename(month, getdate())+'-'+ convert(varchar,year(getdate())) as Month_

No comments:

My first experience with SQL Server Database Partitioning

At my work I have inherited a database where the partitioning was not done correctly.  This database holds millions and millions of records...