SQL change format of Datepart Month

sql format datepart
Ruan picture Ruan · Nov 1, 2012 · Viewed 7.6k times · Source

How do you change the DATEPART format of the month to include the 0 in front of the month?

For instance 5 should be 05.

What I have tried, but none of it works, (only gives me 5)

Createdate = 2008-07-25 13:43:48.000

CONVERT(varchar(2), DATEPART(MONTH,(CreatedDate)))
CONVERT(varchar(2), DATEPART(MM,(CreatedDate)))

Answer

RichardTheKiwi picture RichardTheKiwi · Nov 1, 2012

I often use RIGHT as a cheap way to CONVERT.

select RIGHT(100+MONTH(CreatedDate),2)

Related questions

Oracle SQL - DATE greater than statement

As the title says, I want to find a way to check which of my data sets are past 6 months from SYSDATE via query. SELECT * FROM OrderArchive WHERE OrderDate <= '31 Dec 2014'; I've tried the following but it returns …

Read More
SQL date format convert? [dd.mm.yy to YYYY-MM-DD]

is there mySQL function to convert a date from format dd.mm.yy to YYYY-MM-DD? for example, 03.09.13 -> 2013-09-03.

Read More
Format sql query in TOAD 7.

In toad's older version i can easily able to format the query in Toad's Query editor by right click > Format Code. But in newer version of Toad 7 i can't able to find this Format option. Can any one help …

Read More