Microsoft Logo

Microsoft SQL Sample Code

Format Date Function

The Format Date function is a powerful SQL function you can use to manipulate and work with dates. For example, you may want to format a date to display it in a number of various ways. The example scripts below will show you how to format a date for display in your query results. Note - the format function only works in SQL Server 2008 +

Below is a list of formats and an example of the output.  The date used for all of these examples is "2018-11-07 11:36:14.840".

Query Sample output
SELECT FORMAT (getdate(), 'dd/MM/yyyy ') as date 07/11/2018
SELECT FORMAT (getdate(), 'dd/MM/yyyy, hh:mm:ss ') as date 07/11/2018, 11:36:14
SELECT FORMAT (getdate(), 'dddd, MMMM, yyyy') as date Wednesday, November, 2018
SELECT FORMAT (getdate(), 'MMM dd yyyy') as date Nov 07 2018
SELECT FORMAT (getdate(), 'MM.dd.yy') as date 11.07.18
SELECT FORMAT (getdate(), 'MM-dd-yy') as date 11-07-18
SELECT FORMAT (getdate(), 'hh:mm:ss tt') as date 11:36:14 AM
SELECT FORMAT (getdate(), 'd','us') as date 11/07/2018

If you need any help implementing this function or modifications made for your needs, please Click Here to get a free quote for your Microsoft SQL Development needs. 

Click Here to learn more about the WSI quoting process.

About Us

WSI is a small business and a leading provider of custom SQL Server/Azure programming and database solutions for government entities, Fortune 1000 companies, and emerging businesses. We are your custom SQL Server/Azure development experts.