{"id":235345,"date":"2024-05-15T17:32:47","date_gmt":"2024-05-15T17:32:47","guid":{"rendered":"https:\/\/namso-gen.co\/blog\/?p=235345"},"modified":"2024-05-15T17:32:47","modified_gmt":"2024-05-15T17:32:47","slug":"how-to-get-value-after-decimal-point-in-sql","status":"publish","type":"post","link":"https:\/\/namso-gen.co\/blog\/how-to-get-value-after-decimal-point-in-sql\/","title":{"rendered":"How to get value after decimal point in SQL?"},"content":{"rendered":"<p>If you&#8217;re dealing with numerical data in SQL and need to extract the value after the decimal point, there are several ways to achieve this. One common method is to use the SUBSTRING function along with CHARINDEX to locate the position of the decimal point and extract the desired digits. Another approach is to use the ROUND or TRUNC functions in combination with some arithmetic operations to isolate the decimal portion of the number. Let&#8217;s dive into some examples of how to accomplish this task.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_62 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-value-after-decimal-point-in-sql\/#FAQs\" title=\"FAQs:\">FAQs:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-value-after-decimal-point-in-sql\/#1_Can_I_use_SUBSTRING_to_get_the_value_after_the_decimal_point_in_SQL\" title=\"1. Can I use SUBSTRING to get the value after the decimal point in SQL?\">1. Can I use SUBSTRING to get the value after the decimal point in SQL?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-value-after-decimal-point-in-sql\/#2_How_can_I_use_the_ROUND_function_to_get_the_decimal_part_of_a_number\" title=\"2. How can I use the ROUND function to get the decimal part of a number?\">2. How can I use the ROUND function to get the decimal part of a number?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-value-after-decimal-point-in-sql\/#3_Is_there_a_way_to_extract_the_decimal_part_of_a_number_using_TRUNC_in_SQL\" title=\"3. Is there a way to extract the decimal part of a number using TRUNC in SQL?\">3. Is there a way to extract the decimal part of a number using TRUNC in SQL?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-value-after-decimal-point-in-sql\/#4_What_is_the_difference_between_ROUND_and_TRUNC_functions_for_extracting_the_decimal_part_in_SQL\" title=\"4. What is the difference between ROUND and TRUNC functions for extracting the decimal part in SQL?\">4. What is the difference between ROUND and TRUNC functions for extracting the decimal part in SQL?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-value-after-decimal-point-in-sql\/#5_Can_I_use_mathematical_operations_to_extract_the_decimal_part_in_SQL\" title=\"5. Can I use mathematical operations to extract the decimal part in SQL?\">5. Can I use mathematical operations to extract the decimal part in SQL?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-value-after-decimal-point-in-sql\/#6_How_can_I_handle_negative_numbers_when_extracting_the_decimal_part_in_SQL\" title=\"6. How can I handle negative numbers when extracting the decimal part in SQL?\">6. How can I handle negative numbers when extracting the decimal part in SQL?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-value-after-decimal-point-in-sql\/#7_Is_it_possible_to_convert_the_decimal_part_into_an_integer_in_SQL\" title=\"7. Is it possible to convert the decimal part into an integer in SQL?\">7. Is it possible to convert the decimal part into an integer in SQL?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-value-after-decimal-point-in-sql\/#8_How_can_I_retrieve_the_value_after_the_decimal_point_for_all_rows_in_a_SQL_table\" title=\"8. How can I retrieve the value after the decimal point for all rows in a SQL table?\">8. How can I retrieve the value after the decimal point for all rows in a SQL table?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-value-after-decimal-point-in-sql\/#9_Can_I_use_a_user-defined_function_to_extract_the_decimal_part_in_SQL\" title=\"9. Can I use a user-defined function to extract the decimal part in SQL?\">9. Can I use a user-defined function to extract the decimal part in SQL?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-value-after-decimal-point-in-sql\/#10_Are_there_any_built-in_SQL_functions_specifically_designed_for_extracting_the_decimal_part\" title=\"10. Are there any built-in SQL functions specifically designed for extracting the decimal part?\">10. Are there any built-in SQL functions specifically designed for extracting the decimal part?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-value-after-decimal-point-in-sql\/#11_How_can_I_handle_NULL_values_when_extracting_the_decimal_part_in_SQL\" title=\"11. How can I handle NULL values when extracting the decimal part in SQL?\">11. How can I handle NULL values when extracting the decimal part in SQL?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-value-after-decimal-point-in-sql\/#12_Can_I_use_a_CASE_statement_to_conditionally_extract_the_decimal_part_in_SQL\" title=\"12. Can I use a CASE statement to conditionally extract the decimal part in SQL?\">12. Can I use a CASE statement to conditionally extract the decimal part in SQL?<\/a><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"FAQs\"><\/span>FAQs:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h3><span class=\"ez-toc-section\" id=\"1_Can_I_use_SUBSTRING_to_get_the_value_after_the_decimal_point_in_SQL\"><\/span>1. Can I use SUBSTRING to get the value after the decimal point in SQL?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can use the SUBSTRING function along with CHARINDEX to extract the value after the decimal point. <\/p>\n<h3><span class=\"ez-toc-section\" id=\"2_How_can_I_use_the_ROUND_function_to_get_the_decimal_part_of_a_number\"><\/span>2. How can I use the ROUND function to get the decimal part of a number?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYou can use the ROUND function in SQL to round a number to a specified number of decimal places, and then subtract the original number to get the decimal part.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"3_Is_there_a_way_to_extract_the_decimal_part_of_a_number_using_TRUNC_in_SQL\"><\/span>3. Is there a way to extract the decimal part of a number using TRUNC in SQL?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can use the TRUNC function in SQL to truncate a number to a specified number of decimal places, and then subtract the truncated number from the original number to get the decimal part.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"4_What_is_the_difference_between_ROUND_and_TRUNC_functions_for_extracting_the_decimal_part_in_SQL\"><\/span>4. What is the difference between ROUND and TRUNC functions for extracting the decimal part in SQL?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nThe ROUND function rounds the number to a specified number of decimal places, while the TRUNC function truncates the number to a specified number of decimal places without rounding.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"5_Can_I_use_mathematical_operations_to_extract_the_decimal_part_in_SQL\"><\/span>5. Can I use mathematical operations to extract the decimal part in SQL?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can use mathematical operations like subtraction or modulus to extract the decimal part of a number in SQL.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"6_How_can_I_handle_negative_numbers_when_extracting_the_decimal_part_in_SQL\"><\/span>6. How can I handle negative numbers when extracting the decimal part in SQL?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nWhen dealing with negative numbers, you can use ABS function to convert negative numbers to positive before extracting the decimal part using any of the methods mentioned earlier.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"7_Is_it_possible_to_convert_the_decimal_part_into_an_integer_in_SQL\"><\/span>7. Is it possible to convert the decimal part into an integer in SQL?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can convert the decimal part into an integer by multiplying it with a suitable power of 10 and then truncating the result using the TRUNC function.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"8_How_can_I_retrieve_the_value_after_the_decimal_point_for_all_rows_in_a_SQL_table\"><\/span>8. How can I retrieve the value after the decimal point for all rows in a SQL table?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYou can use a SELECT statement along with the desired method to extract the decimal part of a number for all rows in a SQL table.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"9_Can_I_use_a_user-defined_function_to_extract_the_decimal_part_in_SQL\"><\/span>9. Can I use a user-defined function to extract the decimal part in SQL?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can create a user-defined function (UDF) in SQL to encapsulate the logic for extracting the decimal part of a number and reuse it whenever needed.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"10_Are_there_any_built-in_SQL_functions_specifically_designed_for_extracting_the_decimal_part\"><\/span>10. Are there any built-in SQL functions specifically designed for extracting the decimal part?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nSQL does not have a dedicated function for extracting the decimal part of a number, but you can use existing functions like SUBSTRING, ROUND, or TRUNC in combination to achieve the desired result.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"11_How_can_I_handle_NULL_values_when_extracting_the_decimal_part_in_SQL\"><\/span>11. How can I handle NULL values when extracting the decimal part in SQL?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYou can use the ISNULL function to replace NULL values with a specific value before extracting the decimal part of a number in SQL.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"12_Can_I_use_a_CASE_statement_to_conditionally_extract_the_decimal_part_in_SQL\"><\/span>12. Can I use a CASE statement to conditionally extract the decimal part in SQL?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can use a CASE statement in SQL to conditionally apply different logic for extracting the decimal part based on certain conditions within your data.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you&#8217;re dealing with numerical data in SQL and need to extract the value after the decimal point, there are several ways to achieve this. One common method is to use the SUBSTRING function along with CHARINDEX to locate the position of the decimal point and extract the desired digits. Another approach is to use &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to get value after decimal point in SQL?\" class=\"read-more button\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-value-after-decimal-point-in-sql\/#more-235345\">Read more<span class=\"screen-reader-text\">How to get value after decimal point in SQL?<\/span><\/a><\/p>\n","protected":false},"author":59,"featured_media":107420,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[86279],"tags":[],"class_list":["post-235345","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-learn","no-featured-image-padding"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to get value after decimal point in SQL?<\/title>\n<meta name=\"description\" content=\"If you&#039;re dealing with numerical data in SQL and need to extract the value after the decimal point, there are several ways to achieve this. One common\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-value-after-decimal-point-in-sql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to get value after decimal point in SQL?\" \/>\n<meta property=\"og:description\" content=\"If you&#039;re dealing with numerical data in SQL and need to extract the value after the decimal point, there are several ways to achieve this. One common\" \/>\n<meta property=\"og:url\" content=\"https:\/\/namso-gen.co\/blog\/how-to-get-value-after-decimal-point-in-sql\/\" \/>\n<meta property=\"og:site_name\" content=\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/synchronyfinancial\" \/>\n<meta property=\"article:published_time\" content=\"2024-05-15T17:32:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2024\/03\/faq.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Francis French\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@synchrony\" \/>\n<meta name=\"twitter:site\" content=\"@synchrony\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Francis French\" \/>\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:\/\/namso-gen.co\/blog\/how-to-get-value-after-decimal-point-in-sql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-get-value-after-decimal-point-in-sql\/\"},\"author\":{\"name\":\"Francis French\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/1622769be52c41a10d83bee2c48a8c48\"},\"headline\":\"How to get value after decimal point in SQL?\",\"datePublished\":\"2024-05-15T17:32:47+00:00\",\"dateModified\":\"2024-05-15T17:32:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-get-value-after-decimal-point-in-sql\/\"},\"wordCount\":587,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#organization\"},\"articleSection\":[\"Learn\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/namso-gen.co\/blog\/how-to-get-value-after-decimal-point-in-sql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-get-value-after-decimal-point-in-sql\/\",\"url\":\"https:\/\/namso-gen.co\/blog\/how-to-get-value-after-decimal-point-in-sql\/\",\"name\":\"How to get value after decimal point in SQL?\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#website\"},\"datePublished\":\"2024-05-15T17:32:47+00:00\",\"dateModified\":\"2024-05-15T17:32:47+00:00\",\"description\":\"If you're dealing with numerical data in SQL and need to extract the value after the decimal point, there are several ways to achieve this. One common\",\"breadcrumb\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-get-value-after-decimal-point-in-sql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/namso-gen.co\/blog\/how-to-get-value-after-decimal-point-in-sql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-get-value-after-decimal-point-in-sql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/namso-gen.co\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to get value after decimal point in SQL?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#website\",\"url\":\"https:\/\/namso-gen.co\/blog\/\",\"name\":\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\",\"description\":\"In Namso gen blog you can get many tips regarding to Credit cards, VCC, Credit card security etc. You can generate credit cards by using Namso-gen.co\",\"publisher\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/namso-gen.co\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#organization\",\"name\":\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\",\"url\":\"https:\/\/namso-gen.co\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png\",\"contentUrl\":\"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png\",\"width\":500,\"height\":164,\"caption\":\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\"},\"image\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/synchronyfinancial\",\"https:\/\/twitter.com\/synchrony\",\"https:\/\/www.youtube.com\/synchronyfinancial\",\"https:\/\/www.instagram.com\/synchrony\",\"https:\/\/www.linkedin.com\/company\/synchrony-financial\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/1622769be52c41a10d83bee2c48a8c48\",\"name\":\"Francis French\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g\",\"caption\":\"Francis French\"},\"description\":\"Guest author Francis French has meticulously crafted and revised this article to the best of their knowledge and understanding. Readers are strongly advised to exercise caution, verify information independently, and rely on their own judgment when considering the information provided. Read more articles on Namso Gen here.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to get value after decimal point in SQL?","description":"If you're dealing with numerical data in SQL and need to extract the value after the decimal point, there are several ways to achieve this. One common","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:\/\/namso-gen.co\/blog\/how-to-get-value-after-decimal-point-in-sql\/","og_locale":"en_US","og_type":"article","og_title":"How to get value after decimal point in SQL?","og_description":"If you're dealing with numerical data in SQL and need to extract the value after the decimal point, there are several ways to achieve this. One common","og_url":"https:\/\/namso-gen.co\/blog\/how-to-get-value-after-decimal-point-in-sql\/","og_site_name":"Namso Gen Blog - Free Credit Card Generator [100% Valid]","article_publisher":"https:\/\/www.facebook.com\/synchronyfinancial","article_published_time":"2024-05-15T17:32:47+00:00","og_image":[{"width":1200,"height":630,"url":"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2024\/03\/faq.png","type":"image\/png"}],"author":"Francis French","twitter_card":"summary_large_image","twitter_creator":"@synchrony","twitter_site":"@synchrony","twitter_misc":{"Written by":"Francis French","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/namso-gen.co\/blog\/how-to-get-value-after-decimal-point-in-sql\/#article","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-get-value-after-decimal-point-in-sql\/"},"author":{"name":"Francis French","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/1622769be52c41a10d83bee2c48a8c48"},"headline":"How to get value after decimal point in SQL?","datePublished":"2024-05-15T17:32:47+00:00","dateModified":"2024-05-15T17:32:47+00:00","mainEntityOfPage":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-get-value-after-decimal-point-in-sql\/"},"wordCount":587,"commentCount":0,"publisher":{"@id":"https:\/\/namso-gen.co\/blog\/#organization"},"articleSection":["Learn"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/namso-gen.co\/blog\/how-to-get-value-after-decimal-point-in-sql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/namso-gen.co\/blog\/how-to-get-value-after-decimal-point-in-sql\/","url":"https:\/\/namso-gen.co\/blog\/how-to-get-value-after-decimal-point-in-sql\/","name":"How to get value after decimal point in SQL?","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/#website"},"datePublished":"2024-05-15T17:32:47+00:00","dateModified":"2024-05-15T17:32:47+00:00","description":"If you're dealing with numerical data in SQL and need to extract the value after the decimal point, there are several ways to achieve this. One common","breadcrumb":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-get-value-after-decimal-point-in-sql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/namso-gen.co\/blog\/how-to-get-value-after-decimal-point-in-sql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/namso-gen.co\/blog\/how-to-get-value-after-decimal-point-in-sql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/namso-gen.co\/blog\/"},{"@type":"ListItem","position":2,"name":"How to get value after decimal point in SQL?"}]},{"@type":"WebSite","@id":"https:\/\/namso-gen.co\/blog\/#website","url":"https:\/\/namso-gen.co\/blog\/","name":"Namso Gen Blog - Free Credit Card Generator [100% Valid]","description":"In Namso gen blog you can get many tips regarding to Credit cards, VCC, Credit card security etc. You can generate credit cards by using Namso-gen.co","publisher":{"@id":"https:\/\/namso-gen.co\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/namso-gen.co\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/namso-gen.co\/blog\/#organization","name":"Namso Gen Blog - Free Credit Card Generator [100% Valid]","url":"https:\/\/namso-gen.co\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png","contentUrl":"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png","width":500,"height":164,"caption":"Namso Gen Blog - Free Credit Card Generator [100% Valid]"},"image":{"@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/synchronyfinancial","https:\/\/twitter.com\/synchrony","https:\/\/www.youtube.com\/synchronyfinancial","https:\/\/www.instagram.com\/synchrony","https:\/\/www.linkedin.com\/company\/synchrony-financial"]},{"@type":"Person","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/1622769be52c41a10d83bee2c48a8c48","name":"Francis French","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","caption":"Francis French"},"description":"Guest author Francis French has meticulously crafted and revised this article to the best of their knowledge and understanding. Readers are strongly advised to exercise caution, verify information independently, and rely on their own judgment when considering the information provided. Read more articles on Namso Gen here."}]}},"_links":{"self":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts\/235345","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/users\/59"}],"replies":[{"embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/comments?post=235345"}],"version-history":[{"count":0,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts\/235345\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/media\/107420"}],"wp:attachment":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/media?parent=235345"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/categories?post=235345"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/tags?post=235345"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}