The actual results will vary depending depending on the culture being used. Here’s another: SELECT FORMAT( GETDATE(), 'd') This is just one of many formats that we could choose. Which results in this: Thursday, May 3, 2018 For example, we could do this: SELECT FORMAT( GETDATE(), 'D') Now, we can use the FORMAT() function to format that date and time into our preferred format. We get a result that looks something like this: 02:36:54.480 If we run the following statement: SELECT GETDATE() Raw Dateįirst, here’s what the raw date looks like.

Here’s a basic example of using the FORMAT() function to format a date. The FORMAT() function also accepts an optional “culture” argument, which allows you to specify a language/locale that the results should adhere to. A format string defines how the output should be formatted. The format is supplied as a format string. Simply provide two arguments the date/time and the format to use. In SQL Server, you can use the T-SQL FORMAT() function to format the date and/or time.

How to change time format