Easy Tutorial
Sql Having Sql Func Mid Sql Between Sql Drop Sql Wildcards Sql Join Inner Sql Join Full Sql Func Lcase Sql Where Sql Join Sql Func Round Sql Primarykey Sql Func First Sql Func Len Sql Distinct Sql Func Ucase Sql Function Sql Delete Sql Autoincrement Func Curtime Sql Update Sql Isnull Func Date Sub Sql Constraints Sql Intro Sql Dates Sql Select Into Sql Hosting Sql Create Table Sql Func Format Sql View Sql Func Count Sql Index Sql Like Sql Datatypes General Sql Datatypes Func Convert Sql Func Avg Sql Foreignkey Sql Func Sum Sql Join Right Func Curdate Sql Alias Sql Union Func Date Add Sql Groupby Sql Summary Sql In Sql Null Values Sql Syntax Sql Tutorial Sql Insert Into Select Sql And Or Sql Join Left Sql Func Now Func Date Sql Top Index Sql Create Db Sql Unique Sql Check Func Extract Sql Alter Sql Notnull Func Now Sql Select Sql Insert Sql Func Max Sql Exists Sql Func Min Func Date Format Func Datediff Mysql Func Getdate Sql Orderby Func Datediff Sql Func Last Sql Create Index Func Dateadd Sql Quickref Func Datepart
❮ Sql Datatypes Sql Func Avg ❯

SQL Server CONVERT() Function

Definition and Usage

The CONVERT() function is a general function that converts a date to a new data type.

The CONVERT() function can display date/time data in different formats.

Syntax

Value Description
data_type(length) Specifies the target data type (with an optional length).
expression Specifies the value to be converted.
style Specifies the output format for date/time.

The following table shows the style values for converting datetime or smalldatetime to character data:

Value <br>(Century yy) Value <br>(Century yyyy) Input/Output Standard
- 0 or 100 mon dd yyyy hh:miAM (or PM) Default
1 101 mm/dd/yy USA
2 102 yy.mm.dd ANSI
3 103 dd/mm/yy British/French
4 104 dd.mm.yy German
5 105 dd-mm-yy Italian
6 106 dd mon yy
7 107 Mon dd, yy
8 108 hh:mm:ss
- 9 or 109 mon dd yyyy hh:mi:ss:mmmAM (or PM) Default+millisec
10 110 mm-dd-yy USA
11 111 yy/mm/dd Japan
12 112 yymmdd ISO
- 13 or 113 dd mon yyyy hh:mi:ss:mmm (24h)
14 114 hh:mi:ss:mmm (24h)
- 20 or 120 yyyy-mm-dd hh:mi:ss (24h)
- 21 or 121 yyyy-mm-dd hh:mi:ss.mmm (24h)
- 126 yyyy-mm-ddThh:mi:ss.mmm (no spaces) ISO8601
- 130 dd mon yyyy hh:mi:ss:mmmAM Hijiri
- 131 dd/mm/yy hh:mi:ss:mmmAM Hijiri

Example

The following script uses the CONVERT() function to display different formats. We will use the GETDATE() function to get the current date/time:

Example

SELECT CONVERT(INT, 25.65);

SELECT CONVERT(VARCHAR(19), GETDATE());

SELECT CONVERT(VARCHAR(10), GETDATE(), 10);

SELECT CONVERT(VARCHAR(10), GETDATE(), 110);

SELECT CONVERT(VARCHAR(11), GETDATE(), 6);

SELECT CONVERT(VARCHAR(11), GETDATE(), 106);

SELECT CONVERT(VARCHAR(24), GETDATE(), 113);

The above statements output as:

25
Apr 15 2021 7:59AM
04-15-21
04-15-2021
15 Apr 21
15 Apr 2021
15 Apr 2021 08:03:37:767
❮ Sql Datatypes Sql Func Avg ❯