FORMAT - examples of date formatting

I'm not a long winded blogger, I have work to do. <smiles>

Below are examples of how to use the SQL FORMAT function to format dates. The article for formatting numeric values is here. FORMATMESSAGE can be used, too


Calculate Business Days
CHARINDEX/PATINDEX
Copy ALL the data from one database to another
CROSS APPLY example
CTE Example
CTE Example showing multiple sources, ddv_401k
CTE Example showing Recursion
dd_FL
DELETE into an OUTPUT table
EXCEPT in SQL triggers for Dynamics GP
FORMAT - examples of date formatting
FORMAT - Format a number
FORMAT - Format a number as a percent
FORMATMESSAGE (SQL equivalent to String.Format)
Margin Calculations
RAISERROR - formatting the error string
Running Sum
SQL Bulk Insert
SQL Pivot code
SQL Stuff

... and you 'll find more on the SQL (General) Menu

DECLARE @dt DATETIME

SELECT @dt = '12/21/2016 23:59:58:001'

SELECT FORMAT(@dt,'MM/dd/yyyy') -- returns 12/21/2016

SELECT FORMAT(@dt,'hh:mm:ss') -- returns 11:59:58

SELECT FORMAT(@dt,'HH:mm:ss') -- returns 23:59:58

SELECT FORMAT(GETDATE(),'HH:mm:ss.fff') -- returns 09:20:47.723, showing milliseconds

RealWorldCode gives developers practical, real‑world solutions with clean, working code — no fluff, no theory, just answers.

Links
Home
Knowledge Areas
Sitemap

Contact

Et cetera
Privacy Policy
Terms and Conditions
Cookie Preferences

FORMAT - examples of date formatting

Related Articles

... and you 'll find more on the SQL (General) Menu