Format Date in SQL Server Query

I'm sure this is simple but I can't seem to figure it out. I need to format my date field to just mm/dd. How can I do this in my SQL Query?
LVL 1
Lawrence SalvucciInformation Technology ManagerAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Lee SavidgeConnect With a Mentor Commented:
Or relying on truncation:

select convert(nvarchar(5), getdate(), 101)

Open in new window

0
 
Lee SavidgeCommented:
You could just use:

select right('0' + cast(month(getdate()) as nvarchar(2)), 2) + '/' + right('0' + cast(day(getdate()) as nvarchar(2)), 2)

Open in new window

0
 
Pawan KumarDatabase ExpertCommented:
Please try below. Really easy..

SELECT FORMAT ( GETDATE() , 'MM/dd' ) [MonthDay]

Open in new window

0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
FORMAT function is available since SQL Server 2012. If you're using 2012 version or superior then you can use SELECT FORMAT( @d, 'MM/dd', 'en-US' )
0
 
Lawrence SalvucciInformation Technology ManagerAuthor Commented:
Thank you very much for your quick response. This was the easiest solution and worked exactly how I wanted it to. Thank you again.
0
All Courses

From novice to tech pro — start learning today.