🌐
MSSQLTips
mssqltips.com › home › format sql server dates with format function
Format SQL Server Dates with FORMAT Function
October 31, 2025 - SELECT FORMAT (getdate(), 'd', 'es-bo') as date GO · In Bolivia the format is day, month, year. If this was run for March 21, 2021 the output would be: 21/03/2021. The following table contains different examples for different cultures for October 11, 2021: For a complete list of possible languages, refer to the following link: ... The format also allows to format numbers according to the culture.
🌐
MSSQLTips
mssqltips.com › home › sql date format examples using convert function
SQL Date Format Examples using SQL CONVERT Function
September 26, 2025 - ... SQL Server provides a number of date and time formatting options and in this article we look at how to use SQL CONVERT to output different date/time formats such as mm/dd/yy, mm/dd/yyyy, dd-mm-yyyy, etc.
People also ask

How do I format a date in SQL query?
Use the FORMAT() function to format a date in SQL. Example: SELECT FORMAT(date_column, 'yyyy-MM-dd') FROM table_name;.
🌐
simplilearn.com
simplilearn.com › home › resources › software development › sql date format to convert and format dates easily
SQL Date Format Guide: Syntax & Examples
What are the date formats in SQL TO_DATE?
TO_DATE accepts formats like 'YYYY-MM-DD', 'DD/MM/YYYY', 'MM/DD/YYYY'. You define the format with a format mask, e.g., TO_DATE('01-01-2023', 'DD-MM-YYYY').
🌐
simplilearn.com
simplilearn.com › home › resources › software development › sql date format to convert and format dates easily
SQL Date Format Guide: Syntax & Examples
What is the format of date variable in SQL?
SQL date variables typically use the yyyy-MM-dd format. For example, DATE, DATETIME, or SMALLDATETIME are the defaults in this format.
🌐
simplilearn.com
simplilearn.com › home › resources › software development › sql date format to convert and format dates easily
SQL Date Format Guide: Syntax & Examples
🌐
Microsoft Learn
learn.microsoft.com › en-us › sql › t-sql › functions › format-transact-sql
FORMAT (Transact-SQL) - SQL Server | Microsoft Learn
Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics SQL analytics endpoint in Microsoft Fabric Warehouse in Microsoft Fabric SQL database in Microsoft Fabric · Returns a value formatted with the specified format and optional culture. Use the FORMAT function for locale-aware formatting of date/time and number values as strings.
🌐
W3Schools
w3schools.com › sql › sql_dates.asp
Date Functions in SQL Server and MySQL
String Functions: ASCII CHAR_LENGTH CHARACTER_LENGTH CONCAT CONCAT_WS FIELD FIND_IN_SET FORMAT INSERT INSTR LCASE LEFT LENGTH LOCATE LOWER LPAD LTRIM MID POSITION REPEAT REPLACE REVERSE RIGHT RPAD RTRIM SPACE STRCMP SUBSTR SUBSTRING SUBSTRING_INDEX TRIM UCASE UPPER Numeric Functions: ABS ACOS ASIN ATAN ATAN2 AVG CEIL CEILING COS COT COUNT DEGREES DIV EXP FLOOR GREATEST LEAST LN LOG LOG10 LOG2 MAX MIN MOD PI POW POWER RADIANS RAND ROUND SIGN SIN SQRT SUM TAN TRUNCATE Date Functions: ADDDATE ADDTIME CURDATE CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP CURTIME DATE DATEDIFF DATE_ADD DATE_FORMAT DA
🌐
W3Schools
w3schools.com › sql › func_sqlserver_convert.asp
SQL Server CONVERT() Function
String Functions: ASCII CHAR CHARINDEX CONCAT Concat with + CONCAT_WS DATALENGTH DIFFERENCE FORMAT LEFT LEN LOWER LTRIM NCHAR PATINDEX QUOTENAME REPLACE REPLICATE REVERSE RIGHT RTRIM SOUNDEX SPACE STR STUFF SUBSTRING TRANSLATE TRIM UNICODE UPPER Numeric Functions: ABS ACOS ASIN ATAN ATN2 AVG CEILING COUNT COS COT DEGREES EXP FLOOR LOG LOG10 MAX MIN PI POWER RADIANS RAND ROUND SIGN SIN SQRT SQUARE SUM TAN Date Functions: CURRENT_TIMESTAMP DATEADD DATEDIFF DATEFROMPARTS DATENAME DATEPART DAY GETDATE GETUTCDATE ISDATE MONTH SYSDATETIME YEAR Advanced Functions CAST COALESCE CONVERT CURRENT_USER IIF ISNULL ISNUMERIC NULLIF SESSION_USER SESSIONPROPERTY SYSTEM_USER USER_NAME MS Access Functions
🌐
Simplilearn
simplilearn.com › home › resources › software development › sql date format to convert and format dates easily
SQL Date Format Guide: Syntax & Examples
July 31, 2025 - SQL date variables typically use the yyyy-MM-dd format. For example, DATE, DATETIME, or SMALLDATETIME are the defaults in this format.
🌐
Oracle
docs.oracle.com › en › database › oracle › oracle-database › 19 › sqlrf › Format-Models.html
SQL Language Reference
November 12, 2025 - The datetime format model for the string '11-Nov-1999' is 'DD-Mon-YYYY'. The number format model for the string '$2,304.25' is '$9,999.99'.
🌐
W3Schools
w3schools.com › sql › func_mysql_date_format.asp
MySQL DATE_FORMAT() Function
String Functions: ASCII CHAR_LENGTH CHARACTER_LENGTH CONCAT CONCAT_WS FIELD FIND_IN_SET FORMAT INSERT INSTR LCASE LEFT LENGTH LOCATE LOWER LPAD LTRIM MID POSITION REPEAT REPLACE REVERSE RIGHT RPAD RTRIM SPACE STRCMP SUBSTR SUBSTRING SUBSTRING_INDEX TRIM UCASE UPPER Numeric Functions: ABS ACOS ASIN ATAN ATAN2 AVG CEIL CEILING COS COT COUNT DEGREES DIV EXP FLOOR GREATEST LEAST LN LOG LOG10 LOG2 MAX MIN MOD PI POW POWER RADIANS RAND ROUND SIGN SIN SQRT SUM TAN TRUNCATE Date Functions: ADDDATE ADDTIME CURDATE CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP CURTIME DATE DATEDIFF DATE_ADD DATE_FORMAT DA
Find elsewhere
🌐
MSSQLTips
mssqltips.com › home › sql server format dates, numbers and sql server agent dates
SQL Server FORMAT Dates, Numbers and SQL Server Agent Dates
October 28, 2021 - In my daily DBA work, this function provides lots of convenience that otherwise need some nasty T-SQL conversion and string manipulation work to get the formats I need. In one of my DBA alert emails, I need to include the weekday in one column, something like the following: ... -- tested in SQL Server 2016 use TempDB GO drop table if exists dbo.NewAccount create table dbo.NewAccount(EnrollDate date, NewMembers int go insert into dbo.NewAccount(EnrollDate, NewMembers) values('2019-01-01', 10) ,('2019-01-03', 24) ,('2019-01-11', 12) ,('2019-02-01', 18) ,('2019-02-04', 30 go
🌐
SQL Shack
sqlshack.com › sql-convert-date-functions-and-formats
SQL Convert Date functions and formats
May 21, 2021 - For example, if we have specified interval as Month and Number as 2, it means 2 months needs to be added in date. In the following query, we want to add 2 months in the current date. You can see the output in the following screenshot. Similarly, lets us add 1 year to current date using the following query. We can combine the SQL DATEADD and CONVERT functions to get output in desired DateTime formats...
🌐
Microsoft Learn
learn.microsoft.com › en-us › sql › t-sql › data-types › date-transact-sql
date (Transact-SQL) - SQL Server | Microsoft Learn
Datetime data types allow dates ... is used for down-level clients, complies with the SQL standard form that is defined as yyyy-MM-dd....
🌐
Mytechmantra
mytechmantra.com › home › format sql server dates using format function in sql server
FORMAT SQL Server Dates Using FORMAT Function in SQL Server
June 5, 2022 - Important Note: Format dd represents day number between 1 to 31, MM represents month number between 1 to 12, yy represents two-year digits, and yyyy represents the complete year. To see the output as time in hours, minutes, and seconds, one ...
🌐
W3Schools
w3schools.com › sql › func_sqlserver_format.asp
SQL Server FORMAT() Function
The FORMAT() function formats a value with the specified format (and an optional culture in SQL Server 2017). Use the FORMAT() function to format date/time values and number values.
🌐
Coffingdw
coffingdw.com › how-to-format-dates-in-sql-server-over-1800-examples-included
How to Format Dates in SQL Server – Over 1800 Examples Included – Software connecting all databases
January 18, 2024 - The SQL Server CONVERT statement converts an expression from one data type to another. In the provided examples, you will see that CONVERT is applied to format the current date and time obtained through GETDATE(), which optionally can be a date column, into a varchar data type with different styles or numbering...
Top answer
1 of 12
70

I'm not sure there is an exact match for the format you want. But you can get close with convert() and style 106. Then, replace the spaces:

SELECT replace(convert(NVARCHAR, getdate(), 106), ' ', '/')
2 of 12
51

There are already multiple answers and formatting types for SQL server 2008. But this method somewhat ambiguous and it would be difficult for you to remember the number with respect to Specific Date Format. That's why in next versions of SQL server there is better option.

If you are using SQL Server 2012 or above versions, you should use Format() function

FORMAT ( value, format [, culture ] )

With culture option, you can specify date as per your viewers.

DECLARE @d DATETIME = '10/01/2011';
SELECT FORMAT ( @d, 'd', 'en-US' ) AS 'US English Result'
      ,FORMAT ( @d, 'd', 'en-gb' ) AS 'Great Britain English Result'
      ,FORMAT ( @d, 'd', 'de-de' ) AS 'German Result'
      ,FORMAT ( @d, 'd', 'zh-cn' ) AS 'Simplified Chinese (PRC) Result'; 
  
SELECT FORMAT ( @d, 'D', 'en-US' ) AS 'US English Result'
      ,FORMAT ( @d, 'D', 'en-gb' ) AS 'Great Britain English Result'
      ,FORMAT ( @d, 'D', 'de-de' ) AS 'German Result'
      ,FORMAT ( @d, 'D', 'zh-cn' ) AS 'Chinese (Simplified PRC) Result';

US English Result Great Britain English Result  German Result Simplified Chinese (PRC) Result
----------------  ----------------------------- ------------- -------------------------------------
10/1/2011         01/10/2011                    01.10.2011    2011/10/1

US English Result            Great Britain English Result  German Result                    Chinese (Simplified PRC) Result
---------------------------- ----------------------------- -----------------------------  ---------------------------------------
Saturday, October 01, 2011   01 October 2011               Samstag, 1. Oktober 2011        2011年10月1日
   

For OP's solution, we can use following format, which is already mentioned by @Martin Smith:

FORMAT(GETDATE(), 'dd/MMM/yyyy', 'en-us')

Some sample date formats:

If you want more date formats of SQL server, you should visit:

  1. Custom Date and Time Format
  2. Standard Date and Time Format
🌐
Atlassian
atlassian.com › data › sql › dates
Mastering DATE and TIME in SQL | Atlassian
December 9, 2019 - There are a couple of extra tools you can use on patterns that output numbers. ... For string outputs, most of the patterns above support different casing output based on the case you use for the pattern. Some examples using different casings of “Day”: 1SELECT 2 TO_CHAR(DATE '2023-04-10', 'DAY') AS "DAY", 3 TO_CHAR(DATE '2023-04-10', 'Day') AS "Day", 4 TO_CHAR(DATE '2023-04-10', 'day') AS "day"; And you can see the following common date format in UPPERCASE, Capitalized and lowercase formats:
🌐
Microsoft Learn
learn.microsoft.com › en-us › sql › t-sql › data-types › datetime-transact-sql
datetime (Transact-SQL) - SQL Server | Microsoft Learn
When you use numeric date format, ... (.) as separators. This string must appear in the following form: <number separator number separator number [time] [time]>...
🌐
Codecademy
codecademy.com › docs › sql › date formats
SQL | Date Formats | Codecademy
January 14, 2025 - SELECT FORMAT('2024-12-05', 'dd/MM/yyyy') AS formatted_date; ... Learn to analyze data with SQL and prepare for technical interviews.
🌐
Wise Owl
wiseowl.co.uk › sql › guides › dates-and-times › formatting_dates_and_times_in_sql_server
Formatting Dates and Times in SQL Server
The Format function provides the easiest way to format a date in SQL. Here's an example: ... The date formatting code shows the day name, day number, month name and year number.