{"id":411,"date":"2024-01-09T18:45:12","date_gmt":"2024-01-09T18:45:12","guid":{"rendered":"https:\/\/datacrazyworld.com\/?p=411"},"modified":"2024-01-10T14:21:39","modified_gmt":"2024-01-10T14:21:39","slug":"los-decimales-y-como-perder-precision","status":"publish","type":"post","link":"https:\/\/datacrazyworld.com\/index.php\/2024\/01\/09\/los-decimales-y-como-perder-precision\/","title":{"rendered":"Los decimales y la p\u00e9rdida de precisi\u00f3n"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\u00bfAlguna vez os hab\u00e9is vuelto loc@s con los decimales y los redondeos de las cifras? En esta nueva <em>T-SQLPill<\/em> os cuento algo que me ha pasado recientemente y me he dado cuenta de que lo que cre\u00eda saber no era del todo cierto: todo tiene sus matices si profundizas y lo llevas a situaciones m\u00e1s exigentes.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Manejar cifras, sobre todo las econ\u00f3micas y en el \u00e1mbito profesional, conllevan mucha responsabilidad y hacer operaciones con ellas, muchas veces, no resulta sencillo por los problemas del redondeo o truncamiento de los decimales.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Hasta ahora, no hab\u00eda tenido la necesidad de trabajar con muchos decimales y por tanto mis creencias eran sencillas:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Si tengo un n\u00famero de 2 decimales y lo multiplico por otro n\u00famero de 2 decimales, obtengo uno de cuatro decimales<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"869\" height=\"459\" src=\"https:\/\/datacrazyworld.com\/wp-content\/uploads\/2024\/01\/image-1.png\" alt=\"\" class=\"wp-image-413\" srcset=\"https:\/\/datacrazyworld.com\/wp-content\/uploads\/2024\/01\/image-1.png 869w, https:\/\/datacrazyworld.com\/wp-content\/uploads\/2024\/01\/image-1-300x158.png 300w, https:\/\/datacrazyworld.com\/wp-content\/uploads\/2024\/01\/image-1-768x406.png 768w\" sizes=\"auto, (max-width: 869px) 100vw, 869px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Si tengo un n\u00famero entero y lo divido entre otro n\u00famero entero, obtengo un n\u00famero entero<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"514\" height=\"305\" src=\"https:\/\/datacrazyworld.com\/wp-content\/uploads\/2024\/01\/image-2.png\" alt=\"\" class=\"wp-image-414\" srcset=\"https:\/\/datacrazyworld.com\/wp-content\/uploads\/2024\/01\/image-2.png 514w, https:\/\/datacrazyworld.com\/wp-content\/uploads\/2024\/01\/image-2-300x178.png 300w\" sizes=\"auto, (max-width: 514px) 100vw, 514px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Si tengo un n\u00famero entero y lo divido entre un n\u00famero de 2 decimales, obtengo otro con decimales.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"531\" height=\"321\" src=\"https:\/\/datacrazyworld.com\/wp-content\/uploads\/2024\/01\/image-3.png\" alt=\"\" class=\"wp-image-415\" srcset=\"https:\/\/datacrazyworld.com\/wp-content\/uploads\/2024\/01\/image-3.png 531w, https:\/\/datacrazyworld.com\/wp-content\/uploads\/2024\/01\/image-3-300x181.png 300w\" sizes=\"auto, (max-width: 531px) 100vw, 531px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Pero la pel\u00edcula puede cambiar si se manejan muchos decimales y SQL Server os puede sorprender (o asustar seg\u00fan sea el caso). Veamos un ejemplo.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Ejemplo con muchos decimales<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u00bfCu\u00e1ntos decimales esperar\u00edas obtener en esta operaci\u00f3n?<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">10398,8949131684846258&nbsp;&nbsp; \u00f7&nbsp;&nbsp; 8,5987416971293975<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Las mates nos dicen que el resultado ser\u00eda 1.209,3507724089502509947546875238<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u00bfY SQL Server?<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"886\" height=\"406\" src=\"https:\/\/datacrazyworld.com\/wp-content\/uploads\/2024\/01\/image-4.png\" alt=\"\" class=\"wp-image-416\" srcset=\"https:\/\/datacrazyworld.com\/wp-content\/uploads\/2024\/01\/image-4.png 886w, https:\/\/datacrazyworld.com\/wp-content\/uploads\/2024\/01\/image-4-300x137.png 300w, https:\/\/datacrazyworld.com\/wp-content\/uploads\/2024\/01\/image-4-768x352.png 768w\" sizes=\"auto, (max-width: 886px) 100vw, 886px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u00a1Ups! S\u00f3lo me devuelve 6 decimales.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u00bfY si casteo en un intento de forzar que me devuelva m\u00e1s?<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"886\" height=\"173\" src=\"https:\/\/datacrazyworld.com\/wp-content\/uploads\/2024\/01\/image-5.png\" alt=\"\" class=\"wp-image-417\" srcset=\"https:\/\/datacrazyworld.com\/wp-content\/uploads\/2024\/01\/image-5.png 886w, https:\/\/datacrazyworld.com\/wp-content\/uploads\/2024\/01\/image-5-300x59.png 300w, https:\/\/datacrazyworld.com\/wp-content\/uploads\/2024\/01\/image-5-768x150.png 768w\" sizes=\"auto, (max-width: 886px) 100vw, 886px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">S\u00ed me devuelve m\u00e1s, pero los rellena a 0. \u00bfPor qu\u00e9?<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Profundicemos<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u00a1Vamos a intentar entender algo con la ayuda de estos links!<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Operador \u201c\/\u201d: <a href=\"https:\/\/learn.microsoft.com\/es-es\/sql\/t-sql\/language-elements\/divide-transact-sql?view=sql-server-ver16\" target=\"_blank\" rel=\"noopener\" title=\"\">https:\/\/learn.microsoft.com\/es-es\/sql\/t-sql\/language-elements\/divide-transact-sql?view=sql-server-ver16<\/a><\/li>\n\n\n\n<li>Prioridad de los tipos de datos: <a href=\"https:\/\/learn.microsoft.com\/es-es\/sql\/t-sql\/data-types\/data-type-precedence-transact-sql?view=sql-server-ver16\" target=\"_blank\" rel=\"noopener\" title=\"\">https:\/\/learn.microsoft.com\/es-es\/sql\/t-sql\/data-types\/data-type-precedence-transact-sql?view=sql-server-ver16<\/a><\/li>\n\n\n\n<li>Precisi\u00f3n, escala y longitud: <a href=\"https:\/\/learn.microsoft.com\/es-es\/sql\/t-sql\/data-types\/precision-scale-and-length-transact-sql?view=sql-server-ver16\" target=\"_blank\" rel=\"noopener\" title=\"\">https:\/\/learn.microsoft.com\/es-es\/sql\/t-sql\/data-types\/precision-scale-and-length-transact-sql?view=sql-server-ver16<\/a><\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">Mi primera idea fue acudir al <a href=\"https:\/\/learn.microsoft.com\/es-es\/sql\/t-sql\/language-elements\/divide-transact-sql?view=sql-server-ver16\" target=\"_blank\" rel=\"noopener\" title=\"\">link 1<\/a> para ver qu\u00e9 tipo de dato devolv\u00eda la divisi\u00f3n. Desde ah\u00ed, pas\u00e9 al <a href=\"https:\/\/learn.microsoft.com\/es-es\/sql\/t-sql\/data-types\/data-type-precedence-transact-sql?view=sql-server-ver16\" target=\"_blank\" rel=\"noopener\" title=\"\">link 2<\/a> donde explica, en funci\u00f3n de la prioridad, qu\u00e9 tipo de datos te va a devolver.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Mirando el ranking se explica por qu\u00e9 si yo divid\u00eda un n\u00ba entero entre un n\u00ba decimal, el resultado era un decimal. O si divido un bigint entre un int, el resultado es de tipo bigint.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"411\" height=\"340\" src=\"https:\/\/datacrazyworld.com\/wp-content\/uploads\/2024\/01\/image-6.png\" alt=\"\" class=\"wp-image-418\" srcset=\"https:\/\/datacrazyworld.com\/wp-content\/uploads\/2024\/01\/image-6.png 411w, https:\/\/datacrazyworld.com\/wp-content\/uploads\/2024\/01\/image-6-300x248.png 300w\" sizes=\"auto, (max-width: 411px) 100vw, 411px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Pero me quedaba un fleco por resolver, y es la raz\u00f3n por la que truncaba los decimales a 6. Y a eso da respuesta el <a href=\"https:\/\/learn.microsoft.com\/es-es\/sql\/t-sql\/data-types\/precision-scale-and-length-transact-sql?view=sql-server-ver16\" target=\"_blank\" rel=\"noopener\" title=\"\">link 3<\/a>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Lo primero es entender la diferencia entre Precisi\u00f3n, Escala y Longitud<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Precisi\u00f3n<\/strong>: el n\u00ba de d\u00edgitos de un n\u00ba. <\/li>\n\n\n\n<li><strong>Escala<\/strong>: los n\u00fameros situados a la derecha de la coma.<\/li>\n\n\n\n<li><strong>Longitud<\/strong>: N\u00ba de bytes de almacenamiento.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">En el caso de los datos <em>Numeric <\/em>o <em>Decimal<\/em>, la precisi\u00f3n m\u00e1xima permitida es <strong>38<\/strong>, muy importante tenerlo en cuenta para entender el resto de la explicaci\u00f3n.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Os animo a que le\u00e1is detenidamente esta p\u00e1gina porque te explica en cada operador c\u00f3mo calcula la escala del resultado, pero para el caso que nos ocupa, la explicaci\u00f3n la encontramos en los comentarios:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"886\" height=\"269\" src=\"https:\/\/datacrazyworld.com\/wp-content\/uploads\/2024\/01\/image-7.png\" alt=\"\" class=\"wp-image-419\" srcset=\"https:\/\/datacrazyworld.com\/wp-content\/uploads\/2024\/01\/image-7.png 886w, https:\/\/datacrazyworld.com\/wp-content\/uploads\/2024\/01\/image-7-300x91.png 300w, https:\/\/datacrazyworld.com\/wp-content\/uploads\/2024\/01\/image-7-768x233.png 768w\" sizes=\"auto, (max-width: 886px) 100vw, 886px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Es decir, SQL Server llega un momento que va a truncar a 6 decimales para evitar posibles problemas de desbordamientos y no vais a poder hacer nada para evitarlo, aunque ahora, al menos ya est\u00e1is avisados. \ud83d\ude09<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u00bfAlguna vez os hab\u00e9is vuelto loc@s con los decimales y los redondeos de las cifras? En esta nueva T-SQLPill os cuento algo que me ha pasado recientemente con los decimales.<\/p>\n","protected":false},"author":2,"featured_media":316,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"footnotes":""},"categories":[8,9],"tags":[21,12],"class_list":["post-411","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sqlserver","category-tsql","tag-sqlserver","tag-tsql"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.0.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u00bfAlguna vez os hab\u00e9is vuelto loc@s con los decimales y los redondeos de las cifras? En esta nueva T-SQLPill os cuento algo que me ha pasado recientemente con los decimales.\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Cristina Tarabini-Castellani Ciordia\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/datacrazyworld.com\/index.php\/2024\/01\/09\/los-decimales-y-como-perder-precision\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.0.1\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:site\" content=\"@DataCrazyWorld\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Los decimales y la p\u00e9rdida de precisi\u00f3n - Data Crazy World\" \/>\n\t\t<meta name=\"twitter:description\" content=\"\u00bfAlguna vez os hab\u00e9is vuelto loc@s con los decimales y los redondeos de las cifras? En esta nueva T-SQLPill os cuento algo que me ha pasado recientemente con los decimales.\" \/>\n\t\t<meta name=\"twitter:creator\" content=\"@DataCrazyWorld\" \/>\n\t\t<meta name=\"twitter:image\" content=\"https:\/\/datacrazyworld.com\/wp-content\/uploads\/2022\/12\/Color_Small.png\" \/>\n\t\t<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t\t<meta name=\"twitter:data1\" content=\"Cristina Tarabini-Castellani Ciordia\" \/>\n\t\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura estimado\" \/>\n\t\t<meta name=\"twitter:data2\" content=\"3 minutos\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/2024\\\/01\\\/09\\\/los-decimales-y-como-perder-precision\\\/#blogposting\",\"name\":\"Los decimales y la p\\u00e9rdida de precisi\\u00f3n - Data Crazy World\",\"headline\":\"Los decimales y la p\\u00e9rdida de precisi\\u00f3n\",\"author\":{\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/author\\\/tarabiquetevi\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/#person\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/datacrazyworld.com\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/TSQLPill.png\",\"width\":1200,\"height\":630,\"caption\":\"T-SQL Pill\"},\"datePublished\":\"2024-01-09T18:45:12+00:00\",\"dateModified\":\"2024-01-10T14:21:39+00:00\",\"inLanguage\":\"es-ES\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/2024\\\/01\\\/09\\\/los-decimales-y-como-perder-precision\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/2024\\\/01\\\/09\\\/los-decimales-y-como-perder-precision\\\/#webpage\"},\"articleSection\":\"SQL Server, tsql, sqlserver, tsql\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/2024\\\/01\\\/09\\\/los-decimales-y-como-perder-precision\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/datacrazyworld.com#listItem\",\"position\":1,\"name\":\"Inicio\",\"item\":\"https:\\\/\\\/datacrazyworld.com\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/category\\\/sqlserver\\\/#listItem\",\"name\":\"SQL Server\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/category\\\/sqlserver\\\/#listItem\",\"position\":2,\"name\":\"SQL Server\",\"item\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/category\\\/sqlserver\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/category\\\/sqlserver\\\/tsql\\\/#listItem\",\"name\":\"tsql\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/datacrazyworld.com#listItem\",\"name\":\"Inicio\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/category\\\/sqlserver\\\/tsql\\\/#listItem\",\"position\":3,\"name\":\"tsql\",\"item\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/category\\\/sqlserver\\\/tsql\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/2024\\\/01\\\/09\\\/los-decimales-y-como-perder-precision\\\/#listItem\",\"name\":\"Los decimales y la p\\u00e9rdida de precisi\\u00f3n\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/category\\\/sqlserver\\\/#listItem\",\"name\":\"SQL Server\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/2024\\\/01\\\/09\\\/los-decimales-y-como-perder-precision\\\/#listItem\",\"position\":4,\"name\":\"Los decimales y la p\\u00e9rdida de precisi\\u00f3n\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/category\\\/sqlserver\\\/tsql\\\/#listItem\",\"name\":\"tsql\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/#person\",\"name\":\"Cristina Tarabini-Castellani Ciordia\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/2024\\\/01\\\/09\\\/los-decimales-y-como-perder-precision\\\/#personImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/020df7a271c91fd52178caf747ffe0997d2f1113e00f58e77a2878622e27453f?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"Cristina Tarabini-Castellani Ciordia\"},\"sameAs\":[\"https:\\\/\\\/twitter.com\\\/DataCrazyWorld\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/cristina-tarabini-castellani\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/author\\\/tarabiquetevi\\\/#author\",\"url\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/author\\\/tarabiquetevi\\\/\",\"name\":\"Cristina Tarabini-Castellani Ciordia\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/2024\\\/01\\\/09\\\/los-decimales-y-como-perder-precision\\\/#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/020df7a271c91fd52178caf747ffe0997d2f1113e00f58e77a2878622e27453f?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"Cristina Tarabini-Castellani Ciordia\"},\"sameAs\":[\"https:\\\/\\\/twitter.com\\\/DataCrazyWorld\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/cristina-tarabini-castellani\\\/\"]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/2024\\\/01\\\/09\\\/los-decimales-y-como-perder-precision\\\/#webpage\",\"url\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/2024\\\/01\\\/09\\\/los-decimales-y-como-perder-precision\\\/\",\"name\":\"Los decimales y la p\\u00e9rdida de precisi\\u00f3n - Data Crazy World\",\"description\":\"\\u00bfAlguna vez os hab\\u00e9is vuelto loc@s con los decimales y los redondeos de las cifras? En esta nueva T-SQLPill os cuento algo que me ha pasado recientemente con los decimales.\",\"inLanguage\":\"es-ES\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/2024\\\/01\\\/09\\\/los-decimales-y-como-perder-precision\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/author\\\/tarabiquetevi\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/author\\\/tarabiquetevi\\\/#author\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/datacrazyworld.com\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/TSQLPill.png\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/2024\\\/01\\\/09\\\/los-decimales-y-como-perder-precision\\\/#mainImage\",\"width\":1200,\"height\":630,\"caption\":\"T-SQL Pill\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/2024\\\/01\\\/09\\\/los-decimales-y-como-perder-precision\\\/#mainImage\"},\"datePublished\":\"2024-01-09T18:45:12+00:00\",\"dateModified\":\"2024-01-10T14:21:39+00:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/#website\",\"url\":\"https:\\\/\\\/datacrazyworld.com\\\/\",\"name\":\"DataCrazyWorld\",\"description\":\"SQL Server, PowerShell, Power BI, Power Platform,... Los datos, ese mundo tan interesante, variado, divertido y ... \\u00a1Loco!\",\"inLanguage\":\"es-ES\",\"publisher\":{\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/#person\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Los decimales y la p\u00e9rdida de precisi\u00f3n - Data Crazy World","description":"\u00bfAlguna vez os hab\u00e9is vuelto loc@s con los decimales y los redondeos de las cifras? En esta nueva T-SQLPill os cuento algo que me ha pasado recientemente con los decimales.","canonical_url":"https:\/\/datacrazyworld.com\/index.php\/2024\/01\/09\/los-decimales-y-como-perder-precision\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"https:\/\/datacrazyworld.com\/index.php\/2024\/01\/09\/los-decimales-y-como-perder-precision\/#blogposting","name":"Los decimales y la p\u00e9rdida de precisi\u00f3n - Data Crazy World","headline":"Los decimales y la p\u00e9rdida de precisi\u00f3n","author":{"@id":"https:\/\/datacrazyworld.com\/index.php\/author\/tarabiquetevi\/#author"},"publisher":{"@id":"https:\/\/datacrazyworld.com\/#person"},"image":{"@type":"ImageObject","url":"https:\/\/datacrazyworld.com\/wp-content\/uploads\/2023\/10\/TSQLPill.png","width":1200,"height":630,"caption":"T-SQL Pill"},"datePublished":"2024-01-09T18:45:12+00:00","dateModified":"2024-01-10T14:21:39+00:00","inLanguage":"es-ES","mainEntityOfPage":{"@id":"https:\/\/datacrazyworld.com\/index.php\/2024\/01\/09\/los-decimales-y-como-perder-precision\/#webpage"},"isPartOf":{"@id":"https:\/\/datacrazyworld.com\/index.php\/2024\/01\/09\/los-decimales-y-como-perder-precision\/#webpage"},"articleSection":"SQL Server, tsql, sqlserver, tsql"},{"@type":"BreadcrumbList","@id":"https:\/\/datacrazyworld.com\/index.php\/2024\/01\/09\/los-decimales-y-como-perder-precision\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/datacrazyworld.com#listItem","position":1,"name":"Inicio","item":"https:\/\/datacrazyworld.com","nextItem":{"@type":"ListItem","@id":"https:\/\/datacrazyworld.com\/index.php\/category\/sqlserver\/#listItem","name":"SQL Server"}},{"@type":"ListItem","@id":"https:\/\/datacrazyworld.com\/index.php\/category\/sqlserver\/#listItem","position":2,"name":"SQL Server","item":"https:\/\/datacrazyworld.com\/index.php\/category\/sqlserver\/","nextItem":{"@type":"ListItem","@id":"https:\/\/datacrazyworld.com\/index.php\/category\/sqlserver\/tsql\/#listItem","name":"tsql"},"previousItem":{"@type":"ListItem","@id":"https:\/\/datacrazyworld.com#listItem","name":"Inicio"}},{"@type":"ListItem","@id":"https:\/\/datacrazyworld.com\/index.php\/category\/sqlserver\/tsql\/#listItem","position":3,"name":"tsql","item":"https:\/\/datacrazyworld.com\/index.php\/category\/sqlserver\/tsql\/","nextItem":{"@type":"ListItem","@id":"https:\/\/datacrazyworld.com\/index.php\/2024\/01\/09\/los-decimales-y-como-perder-precision\/#listItem","name":"Los decimales y la p\u00e9rdida de precisi\u00f3n"},"previousItem":{"@type":"ListItem","@id":"https:\/\/datacrazyworld.com\/index.php\/category\/sqlserver\/#listItem","name":"SQL Server"}},{"@type":"ListItem","@id":"https:\/\/datacrazyworld.com\/index.php\/2024\/01\/09\/los-decimales-y-como-perder-precision\/#listItem","position":4,"name":"Los decimales y la p\u00e9rdida de precisi\u00f3n","previousItem":{"@type":"ListItem","@id":"https:\/\/datacrazyworld.com\/index.php\/category\/sqlserver\/tsql\/#listItem","name":"tsql"}}]},{"@type":"Person","@id":"https:\/\/datacrazyworld.com\/#person","name":"Cristina Tarabini-Castellani Ciordia","image":{"@type":"ImageObject","@id":"https:\/\/datacrazyworld.com\/index.php\/2024\/01\/09\/los-decimales-y-como-perder-precision\/#personImage","url":"https:\/\/secure.gravatar.com\/avatar\/020df7a271c91fd52178caf747ffe0997d2f1113e00f58e77a2878622e27453f?s=96&d=mm&r=g","width":96,"height":96,"caption":"Cristina Tarabini-Castellani Ciordia"},"sameAs":["https:\/\/twitter.com\/DataCrazyWorld","https:\/\/www.linkedin.com\/in\/cristina-tarabini-castellani\/"]},{"@type":"Person","@id":"https:\/\/datacrazyworld.com\/index.php\/author\/tarabiquetevi\/#author","url":"https:\/\/datacrazyworld.com\/index.php\/author\/tarabiquetevi\/","name":"Cristina Tarabini-Castellani Ciordia","image":{"@type":"ImageObject","@id":"https:\/\/datacrazyworld.com\/index.php\/2024\/01\/09\/los-decimales-y-como-perder-precision\/#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/020df7a271c91fd52178caf747ffe0997d2f1113e00f58e77a2878622e27453f?s=96&d=mm&r=g","width":96,"height":96,"caption":"Cristina Tarabini-Castellani Ciordia"},"sameAs":["https:\/\/twitter.com\/DataCrazyWorld","https:\/\/www.linkedin.com\/in\/cristina-tarabini-castellani\/"]},{"@type":"WebPage","@id":"https:\/\/datacrazyworld.com\/index.php\/2024\/01\/09\/los-decimales-y-como-perder-precision\/#webpage","url":"https:\/\/datacrazyworld.com\/index.php\/2024\/01\/09\/los-decimales-y-como-perder-precision\/","name":"Los decimales y la p\u00e9rdida de precisi\u00f3n - Data Crazy World","description":"\u00bfAlguna vez os hab\u00e9is vuelto loc@s con los decimales y los redondeos de las cifras? En esta nueva T-SQLPill os cuento algo que me ha pasado recientemente con los decimales.","inLanguage":"es-ES","isPartOf":{"@id":"https:\/\/datacrazyworld.com\/#website"},"breadcrumb":{"@id":"https:\/\/datacrazyworld.com\/index.php\/2024\/01\/09\/los-decimales-y-como-perder-precision\/#breadcrumblist"},"author":{"@id":"https:\/\/datacrazyworld.com\/index.php\/author\/tarabiquetevi\/#author"},"creator":{"@id":"https:\/\/datacrazyworld.com\/index.php\/author\/tarabiquetevi\/#author"},"image":{"@type":"ImageObject","url":"https:\/\/datacrazyworld.com\/wp-content\/uploads\/2023\/10\/TSQLPill.png","@id":"https:\/\/datacrazyworld.com\/index.php\/2024\/01\/09\/los-decimales-y-como-perder-precision\/#mainImage","width":1200,"height":630,"caption":"T-SQL Pill"},"primaryImageOfPage":{"@id":"https:\/\/datacrazyworld.com\/index.php\/2024\/01\/09\/los-decimales-y-como-perder-precision\/#mainImage"},"datePublished":"2024-01-09T18:45:12+00:00","dateModified":"2024-01-10T14:21:39+00:00"},{"@type":"WebSite","@id":"https:\/\/datacrazyworld.com\/#website","url":"https:\/\/datacrazyworld.com\/","name":"DataCrazyWorld","description":"SQL Server, PowerShell, Power BI, Power Platform,... Los datos, ese mundo tan interesante, variado, divertido y ... \u00a1Loco!","inLanguage":"es-ES","publisher":{"@id":"https:\/\/datacrazyworld.com\/#person"}}]},"twitter:card":"summary_large_image","twitter:site":"@DataCrazyWorld","twitter:title":"Los decimales y la p\u00e9rdida de precisi\u00f3n - Data Crazy World","twitter:description":"\u00bfAlguna vez os hab\u00e9is vuelto loc@s con los decimales y los redondeos de las cifras? En esta nueva T-SQLPill os cuento algo que me ha pasado recientemente con los decimales.","twitter:creator":"@DataCrazyWorld","twitter:image":"https:\/\/datacrazyworld.com\/wp-content\/uploads\/2022\/12\/Color_Small.png","twitter:label1":"Escrito por","twitter:data1":"Cristina Tarabini-Castellani Ciordia","twitter:label2":"Tiempo de lectura estimado","twitter:data2":"3 minutos"},"aioseo_meta_data":{"post_id":"411","title":null,"description":null,"keywords":[],"keyphrases":{"focus":{"keyphrase":"","score":0,"analysis":{"keyphraseInTitle":{"score":0,"maxScore":9,"error":1}}},"additional":[]},"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":"","og_custom_url":null,"og_article_section":null,"og_article_tags":[],"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"BlogPosting","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":"-1","robots_max_videopreview":"-1","robots_max_imagepreview":"large","priority":null,"frequency":"default","local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2024-01-09 18:08:32","updated":"2025-06-04 03:42:51","seo_analyzer_scan_date":null,"focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/datacrazyworld.com\" title=\"Inicio\">Inicio<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/datacrazyworld.com\/index.php\/category\/sqlserver\/\" title=\"SQL Server\">SQL Server<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/datacrazyworld.com\/index.php\/category\/sqlserver\/tsql\/\" title=\"tsql\">tsql<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tLos decimales y la p\u00e9rdida de precisi\u00f3n\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Inicio","link":"https:\/\/datacrazyworld.com"},{"label":"SQL Server","link":"https:\/\/datacrazyworld.com\/index.php\/category\/sqlserver\/"},{"label":"tsql","link":"https:\/\/datacrazyworld.com\/index.php\/category\/sqlserver\/tsql\/"},{"label":"Los decimales y la p\u00e9rdida de precisi\u00f3n","link":"https:\/\/datacrazyworld.com\/index.php\/2024\/01\/09\/los-decimales-y-como-perder-precision\/"}],"_links":{"self":[{"href":"https:\/\/datacrazyworld.com\/index.php\/wp-json\/wp\/v2\/posts\/411","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/datacrazyworld.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datacrazyworld.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datacrazyworld.com\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/datacrazyworld.com\/index.php\/wp-json\/wp\/v2\/comments?post=411"}],"version-history":[{"count":8,"href":"https:\/\/datacrazyworld.com\/index.php\/wp-json\/wp\/v2\/posts\/411\/revisions"}],"predecessor-version":[{"id":437,"href":"https:\/\/datacrazyworld.com\/index.php\/wp-json\/wp\/v2\/posts\/411\/revisions\/437"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datacrazyworld.com\/index.php\/wp-json\/wp\/v2\/media\/316"}],"wp:attachment":[{"href":"https:\/\/datacrazyworld.com\/index.php\/wp-json\/wp\/v2\/media?parent=411"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datacrazyworld.com\/index.php\/wp-json\/wp\/v2\/categories?post=411"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datacrazyworld.com\/index.php\/wp-json\/wp\/v2\/tags?post=411"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}