Convert Month Number to Month Name Function in SQL
Posted By: Saif Khan
I have months stored in SQL Server as 1,2,3,4,…12. I would like to display them as January,February etc. Is there a function in SQL Server like MonthName(1) = January? I am trying to avoid a CASE statement, if possible.
Solution
A little hacky but should work:
SELECT DATENAME(month, DATEADD(month, @mydate-1, CAST('2008-01-01' AS datetime)))
Answered By: Alexander Kojevnikov
Related Articles
- add scroll bar to table body
- Can't find why this datetime test fails, in F#
- Get week day name from a given month, day and year…
- Obtain most recent value for based on index in a…
- Difference in Months between two dates in JavaScript
- How to add a unique id to an array in one loop…
- Javascript add leading zeroes to date
- Converting between datetime, Timestamp and datetime64
- Polymer nested dom-repeat templates are not updating…
- How to return only the Date from a SQL Server…
- ternary operator usage within v-bind class
- Why does `this` inside filter() gets undefined in VueJS?
- Using two values for one switch case statement
- How to print a date in a regular format?
- get UTC timestamp in python with datetime
- How to increment datetime by custom months in python…
- type object 'datetime.datetime' has no attribute 'datetime'
- SMTP error 554
- Best way to find the months between two dates
- T-SQL datetime rounded to nearest minute and nearest…
- java.util.Date format conversion yyyy-mm-dd to mm-dd-yyyy
- How to convert number to words in java
- How can I truncate a datetime in SQL Server?
- How can I compare time in SQL Server?
- "import datetime" v.s. "from datetime import datetime"
- Difference between System.DateTime.Now and…
- How to get the first and last date of the current year?
- $(this).val() not working to get text from span using jquery
- JavaScript function to add X months to a date
- vuejs conditional binding a class based on the data
- Get first day of week in SQL Server
- Using DateTime in a SqlParameter for Stored…
- Should MySQL have its timezone set to UTC?
- How to truncate milliseconds off of a .NET DateTime
- How to calculate age in T-SQL with years, months, and days
- Calculate time difference in minutes in SQL Server
- Subtract three rows from an array in angular 7
- Best approach to remove time part of datetime in SQL Server
- Best way to do multi-row insert in Oracle?
- Polymer CSS inline elements alignment
- How to change date format in JavaScript
- Creating a JavaScript cookie on a domain and reading…
- How do I add Internet Explorer 10 support to a…
- Convert number to month name in PHP
- Pass multiple parameters to rest API - Spring
- Sort table rows In Bootstrap
- MS SQL Date Only Without Time
- Convert a python UTC datetime to a local datetime…
- MySQL/SQL: Group by date only on a Datetime column
- Persistent invalid graphics state error when using ggplot2
- Java string to date conversion
- What is the standard way to add N seconds to…
- How to make an unaware datetime timezone aware in python
- Conversion failed when converting the varchar value…
- WHILE LOOP with IF STATEMENT MYSQL
- Converting dd/mm/yyyy formatted string to Datetime
- How do I properly set the Datetimeindex for a Pandas…
- Subtracting Dates in Oracle - Number or Interval Datatype?
- How to create Temp table with SELECT * INTO…
- How to use Date objects in local timezone with…
- Is this request generated by EF Core buggy or is it my code?
- How to convert date to timestamp?
- How can I select the first day of a month in SQL?
- Conversion of a varchar data type to a datetime data…
- How do I calculate the date in JavaScript three…
- How to add three months from incoming API dates using C#?
- SQL Server: Query fast, but slow from procedure
- Combining (concatenating) date and time into a datetime
- Type datetime for input parameter in procedure
- calculating the difference in months between two dates
- sql server Get the FULL month name from a date
- Creating a typescript definition file for a vue…
- Convert datetime to Unix timestamp and convert it…
- Java 8: Difference between two LocalDateTime in…
- Generate SQL Create Scripts for existing tables with Query
- Reporting Services Remove Time from DateTime in Expression
- How to properly use the "choices" field option in Django
- Returning Month Name in SQL Server Query
- vue.js render table with rowspans
- How to combine date from one field with time from…
- How do I convert a factor into date format?
- How to get min max day in a week every month?
- Get day of week in SQL Server 2005/2008
- Using SELECT result in another SELECT
- Calculate last day of month in JavaScript
- Convert python datetime to epoch with strftime
- Get Month name from month number
- How to get the day of week and the month of the year?
- Convert INT to DATETIME (SQL)
- Convert Year/Month/Day to Day of Year in Python
- Returning a C string from a function
- Converting string into datetime
- VBScript How can I Format Date?
- Select SQL Server database size
- vue.js referencing constants in data?
- Java Class.cast() vs. cast operator
- Creating list with the same number of values
- Convert string into Date type on Python
- How do I pass a datetime value as a URI parameter in…
- Using BETWEEN in CASE SQL statement
Disclaimer: This content is shared under creative common license cc-by-sa 3.0. It is generated from StackExchange Website Network.
