{"id":9311,"date":"2019-02-11T07:09:17","date_gmt":"2019-02-11T07:09:17","guid":{"rendered":"https:\/\/dbtut.com\/?p=9311"},"modified":"2019-02-12T06:40:09","modified_gmt":"2019-02-12T06:40:09","slug":"cast-and-convert-functions-in-sql-servertsql","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/02\/11\/cast-and-convert-functions-in-sql-servertsql\/","title":{"rendered":"CAST and CONVERT Functions in SQL Server(TSQL)"},"content":{"rendered":"

 <\/p>\n

The CAST and CONVERT functions are conversion functions. We use these functions to convert a data type to another data type. Of course, every data can not be converted to each data type. For example, if the value of a data with a data type varchar is “123”, it can be converted to an int data type. However, if the value of the data is “mytext”, the data cannot be converted to int data type.<\/p>\n

Difference Between CAST and CONVERT:<\/h3>\n

The CAST Function is an ANSI standard. It is also supported by some other databases.<\/p>\n

Convert is a SQL Server-specific function. It is more flexible and more capable than CAST.<\/p>\n

In general, I suggest you choose to use CAST. If CAST does not meet your needs, you can choose CONVERT. The CONVERT function is especially useful when you want to display the datetime data type in a format you want.<\/p>\n

The syntax of the two functions is different. You can see these differences in the following examples.<\/p>\n

Let’s make examples for a better understanding of CAST and CONVET Functions.<\/p>\n

Example:<\/strong><\/p>\n

We will do our examples on a dataset as follows. Original data types are as follows. The database we use is AdventureWorks2012.<\/p>\n\n\n\n\n\n\n
[Name]<\/td>\nvarchar(50)<\/td>\n<\/tr>\n
[ListPrice]<\/td>\nmoney<\/td>\n<\/tr>\n
[ModifiedDate]<\/td>\ndatetime<\/td>\n<\/tr>\n
[Size]<\/td>\nnvarchar(5)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
SELECT TOP (5)\r\n\u00a0\u00a0\u00a0[Name]\u00a0\u00a0\u00a0\r\n\u00a0\u00a0,[ListPrice]\r\n\u00a0 ,[ModifiedDate]\r\n\u00a0 ,[Size]\u00a0\u00a0\u00a0\r\n\u00a0 FROM [AdventureWorks2012].[Production].[Product]\r\n\u00a0 WHERE ListPrice>10 AND Size is not null<\/pre>\n
\"\"<\/p>\n
Convert ListPrice column(data type is money) to varchar and int data type:<\/strong><\/p>\n
SELECT TOP (5)\r\n\u00a0\u00a0\u00a0[Name]\r\n\u00a0 ,CONVERT(varchar(10), ListPrice) AS ListPrice\r\n\u00a0\u00a0,CAST(ListPrice AS varchar(10)) AS ListPrice\r\n\u00a0 ,CONVERT(int, ListPrice) AS ListPrice\r\n\u00a0\u00a0,CAST(ListPrice AS int) AS ListPrice\r\n\u00a0 ,[ModifiedDate]\r\n\u00a0 ,[Size]\u00a0\u00a0\u00a0\r\n\u00a0 FROM [AdventureWorks2012].[Production].[Product]\r\n\u00a0 WHERE ListPrice>10 AND Size is not null<\/pre>\n
\"\"<\/p>\n
Convert Size column(data type is nvarchar) to int data type:<\/strong><\/p>\n
It will receive the following error due to values that are not compatible with the int data type in the “Size” column.<\/p>\n
SELECT TOP (5)\r\n\u00a0\u00a0\u00a0[Name]\r\n\u00a0 ,[ListPrice]\r\n\u00a0 ,[ModifiedDate]\r\n\u00a0 ,CONVERT(int, Size) AS Size\r\n\u00a0\u00a0,CAST(Size AS int) AS Size\r\n\u00a0 FROM [AdventureWorks2012].[Production].[Product]\r\n\u00a0 WHERE ListPrice>10 AND Size is not null<\/pre>\n
Msg 245, Level 16, State 1, Line 5<\/em><\/span><\/p>\n
Conversion failed when converting the nvarchar value ‘S’ to data type int.<\/em><\/span><\/p>\n
 <\/p>\n
\"\"<\/p>\n
But when you go to the Results tab, you will see that the data types that are compatible with the int data type are returned as a result.<\/p>\n
\"\"<\/p>\n
Convert the ModifiedDate column(data type is datetime) to the varchar data type:<\/strong><\/p>\n
SELECT TOP (5)\r\n\u00a0\u00a0\u00a0[Name]\r\n\u00a0 ,[ListPrice]\r\n\u00a0 ,[ModifiedDate]\r\n\u00a0 ,CONVERT(varchar(50), ModifiedDate) AS [ModifiedDate]\r\n\u00a0\u00a0,CAST(ModifiedDate AS varchar(50)) AS [ModifiedDate]\r\n\u00a0 ,[Size]\r\n\u00a0 FROM [AdventureWorks2012].[Production].[Product]\r\n\u00a0 WHERE ListPrice>10 AND Size is not null<\/pre>\n
\"\"<\/p>\n
The difference of the CONVERT function is obvious here. With the CONVERT function, we can change the format that we want to show the date as follows.<\/p>\n
SELECT TOP (5)\r\n\u00a0\u00a0\u00a0[Name]\r\n\u00a0 ,[ListPrice]\r\n\u00a0 ,[ModifiedDate]\r\n\u00a0 ,CONVERT(varchar(50), ModifiedDate,101) AS [ModifiedDate]\r\n  ,CAST(ModifiedDate AS varchar(50)) AS [ModifiedDate]\r\n\u00a0 ,[Size]\r\n\u00a0 FROM [AdventureWorks2012].[Production].[Product]\r\n\u00a0 WHERE ListPrice>10 AND Size is not null<\/pre>\n
\"\"<\/p>\n
Below you can see the formats you can choose.<\/p>\n
\n
\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\n
100<\/p>\n<\/td>\n
\n
mon dd yyyy hh:miAM\/PM<\/p>\n<\/td>\n<\/tr>\n
\n
101<\/p>\n<\/td>\n
\n
mm\/dd\/yyyy<\/p>\n<\/td>\n<\/tr>\n
\n
102<\/p>\n<\/td>\n
\n
\u00a0<\/span>yyyy.mm.dd<\/span><\/p>\n<\/td>\n<\/tr>\n
\n
103<\/p>\n<\/td>\n
\n
\u00a0<\/span>dd\/mm\/yyyy<\/span><\/p>\n<\/td>\n<\/tr>\n
\n
104<\/p>\n<\/td>\n
\n
dd.mm.yyyy<\/p>\n<\/td>\n<\/tr>\n
\n
105<\/p>\n<\/td>\n
\n
\u00a0<\/span>dd-mm-yyyy<\/span><\/p>\n<\/td>\n<\/tr>\n
\n
106<\/p>\n<\/td>\n
\n
dd mon yyyy<\/p>\n<\/td>\n<\/tr>\n
\n
107<\/p>\n<\/td>\n
\n
Mon dd, yyyy<\/p>\n<\/td>\n<\/tr>\n
\n
108<\/p>\n<\/td>\n
\n
hh:mm:ss<\/p>\n<\/td>\n<\/tr>\n
\n
109<\/p>\n<\/td>\n
\n
mon dd yyyy hh:mi:ss:mmmAM\/PM<\/p>\n<\/td>\n<\/tr>\n
\n
110<\/p>\n<\/td>\n
\n
mm-dd-yyyy<\/p>\n<\/td>\n<\/tr>\n
\n
111<\/p>\n<\/td>\n
\n
\u00a0<\/span>yyyy\/mm\/dd<\/span><\/p>\n<\/td>\n<\/tr>\n
\n
112<\/p>\n<\/td>\n
\n
\u00a0<\/span>yyyymmdd<\/span><\/p>\n<\/td>\n<\/tr>\n
\n
113<\/p>\n<\/td>\n
\n
dd mon yyyy hh:mi:ss:mmm<\/p>\n<\/td>\n<\/tr>\n
\n
114<\/p>\n<\/td>\n
\n
hh:mi:ss:mmm<\/p>\n<\/td>\n<\/tr>\n
\n
120<\/p>\n<\/td>\n
\n
yyyy-mm-dd hh:mi:ss<\/p>\n<\/td>\n<\/tr>\n
\n
121<\/p>\n<\/td>\n
\n
yyyy-mm-dd hh:mi:ss.mmm<\/p>\n<\/td>\n<\/tr>\n
\n
126<\/p>\n<\/td>\n
\n
yyyy-mm-ddThh:mi:ss.mmm<\/p>\n<\/td>\n<\/tr>\n
\n
127<\/p>\n<\/td>\n
\n
yyyy-mm-ddThh:mi:ss.mmm with timezone<\/p>\n<\/td>\n<\/tr>\n
\n
130<\/p>\n<\/td>\n
\n
dd mon yyyy hh:mi:ss:mmmAM\/PM<\/p>\n<\/td>\n<\/tr>\n
\n
131<\/p>\n<\/td>\n
\n
dd\/mm\/yy hh:mi:ss:mmmAM\/PM<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n<\/div>\n
 <\/p>\n
 <\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
  The CAST and CONVERT functions are conversion functions. We use these functions to convert a data type to another data type. Of course, every data can not be converted to each data type. For example, if the value of a data with a data type varchar is “123”, it can be converted to an …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[3,1596],"tags":[1990,1992,1650,1991,1994,1993,1995],"class_list":["post-9311","post","type-post","status-publish","format-standard","","category-mssql","category-tsql","tag-cast-function","tag-cast-function-in-tsql","tag-conversion-failed-when-converting-the-nvarchar-value-to-data-type-int","tag-convert-function","tag-convert-function-datetime-formats","tag-convert-function-in-tsql","tag-difference-between-cast-and-convert"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":505,"today_views":1},"yoast_head":"\nCAST and CONVERT Functions in SQL Server(TSQL) - Database Tutorials<\/title>\n<meta name=\"description\" content=\"CAST and CONVERT Functions in SQL Server(TSQL)\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2019\/02\/11\/cast-and-convert-functions-in-sql-servertsql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"CAST and CONVERT Functions in SQL Server(TSQL) - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"CAST and CONVERT Functions in SQL Server(TSQL)\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/02\/11\/cast-and-convert-functions-in-sql-servertsql\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-02-11T07:09:17+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-02-12T06:40:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c611e1eb5ea4.png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/11\/cast-and-convert-functions-in-sql-servertsql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/11\/cast-and-convert-functions-in-sql-servertsql\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"CAST and CONVERT Functions in SQL Server(TSQL)\",\"datePublished\":\"2019-02-11T07:09:17+00:00\",\"dateModified\":\"2019-02-12T06:40:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/11\/cast-and-convert-functions-in-sql-servertsql\/\"},\"wordCount\":450,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/11\/cast-and-convert-functions-in-sql-servertsql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c611e1eb5ea4.png\",\"keywords\":[\"CAST Function\",\"CAST Function in TSQL\",\"Conversion failed when converting the nvarchar value '' to data type int.\",\"CONVERT Function\",\"CONVERT Function datetime formats\",\"Convert Function in TSQL\",\"Difference Between CAST and CONVERT\"],\"articleSection\":[\"MSSQL\",\"TSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/02\/11\/cast-and-convert-functions-in-sql-servertsql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/11\/cast-and-convert-functions-in-sql-servertsql\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/11\/cast-and-convert-functions-in-sql-servertsql\/\",\"name\":\"CAST and CONVERT Functions in SQL Server(TSQL) - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/11\/cast-and-convert-functions-in-sql-servertsql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/11\/cast-and-convert-functions-in-sql-servertsql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c611e1eb5ea4.png\",\"datePublished\":\"2019-02-11T07:09:17+00:00\",\"dateModified\":\"2019-02-12T06:40:09+00:00\",\"description\":\"CAST and CONVERT Functions in SQL Server(TSQL)\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/11\/cast-and-convert-functions-in-sql-servertsql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/02\/11\/cast-and-convert-functions-in-sql-servertsql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/11\/cast-and-convert-functions-in-sql-servertsql\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c611e1eb5ea4.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c611e1eb5ea4.png\",\"width\":891,\"height\":444},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/11\/cast-and-convert-functions-in-sql-servertsql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"CAST and CONVERT Functions in SQL Server(TSQL)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"CAST and CONVERT Functions in SQL Server(TSQL) - Database Tutorials","description":"CAST and CONVERT Functions in SQL Server(TSQL)","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2019\/02\/11\/cast-and-convert-functions-in-sql-servertsql\/","og_locale":"en_US","og_type":"article","og_title":"CAST and CONVERT Functions in SQL Server(TSQL) - Database Tutorials","og_description":"CAST and CONVERT Functions in SQL Server(TSQL)","og_url":"https:\/\/dbtut.com\/index.php\/2019\/02\/11\/cast-and-convert-functions-in-sql-servertsql\/","og_site_name":"Database Tutorials","article_published_time":"2019-02-11T07:09:17+00:00","article_modified_time":"2019-02-12T06:40:09+00:00","og_image":[{"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c611e1eb5ea4.png","type":"","width":"","height":""}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/11\/cast-and-convert-functions-in-sql-servertsql\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/11\/cast-and-convert-functions-in-sql-servertsql\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"CAST and CONVERT Functions in SQL Server(TSQL)","datePublished":"2019-02-11T07:09:17+00:00","dateModified":"2019-02-12T06:40:09+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/11\/cast-and-convert-functions-in-sql-servertsql\/"},"wordCount":450,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/11\/cast-and-convert-functions-in-sql-servertsql\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c611e1eb5ea4.png","keywords":["CAST Function","CAST Function in TSQL","Conversion failed when converting the nvarchar value '' to data type int.","CONVERT Function","CONVERT Function datetime formats","Convert Function in TSQL","Difference Between CAST and CONVERT"],"articleSection":["MSSQL","TSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/02\/11\/cast-and-convert-functions-in-sql-servertsql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/11\/cast-and-convert-functions-in-sql-servertsql\/","url":"https:\/\/dbtut.com\/index.php\/2019\/02\/11\/cast-and-convert-functions-in-sql-servertsql\/","name":"CAST and CONVERT Functions in SQL Server(TSQL) - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/11\/cast-and-convert-functions-in-sql-servertsql\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/11\/cast-and-convert-functions-in-sql-servertsql\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c611e1eb5ea4.png","datePublished":"2019-02-11T07:09:17+00:00","dateModified":"2019-02-12T06:40:09+00:00","description":"CAST and CONVERT Functions in SQL Server(TSQL)","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/11\/cast-and-convert-functions-in-sql-servertsql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/02\/11\/cast-and-convert-functions-in-sql-servertsql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/11\/cast-and-convert-functions-in-sql-servertsql\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c611e1eb5ea4.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c611e1eb5ea4.png","width":891,"height":444},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/11\/cast-and-convert-functions-in-sql-servertsql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"CAST and CONVERT Functions in SQL Server(TSQL)"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/9311","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=9311"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/9311\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=9311"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=9311"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=9311"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}