---
title: "month in word formate in sql server"  
description: "month in word formate in sql server"  
author: "Jayden Bell"  
published: 2013-01-25  
updated: 2013-01-28  
canonical: https://www.mindstick.com/forum/545/month-in-word-formate-in-sql-server  
category: "mssql server"  
tags: ["mssql server"]  
reading_time: 1 minute  

---

# month in word formate in sql server

Hi Everyone!\
\
I want to display month in [word](https://www.mindstick.com/forum/305/read-word-file) formate in [SQL server](https://www.mindstick.com/articles/12999/what-is-table-valued-function-in-sql-server) 2008. e.g. 25 [Jan](https://yourviews.mindstick.com/story/3798/why-we-celebrate-26-jan-republic-day-of-india) 2013 00:00:00. can you help me?\
\
Thanks in [advance](https://www.mindstick.com/blog/33258/jee-mains-and-jee-advance-exams)

## Replies

### Reply by AVADHESH PATEL

Hi Jayden Bell \
\
You can try this line of code \
\
SELECT CONVERT(VARCHAR(50),GETDATE(),113)


---

Original Source: https://www.mindstick.com/forum/545/month-in-word-formate-in-sql-server

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.