{"id":235353,"date":"2024-06-20T21:08:40","date_gmt":"2024-06-20T21:08:40","guid":{"rendered":"https:\/\/namso-gen.co\/blog\/?p=235353"},"modified":"2024-06-20T21:08:40","modified_gmt":"2024-06-20T21:08:40","slug":"how-to-get-value-before-decimal-point-in-sql","status":"publish","type":"post","link":"https:\/\/namso-gen.co\/blog\/how-to-get-value-before-decimal-point-in-sql\/","title":{"rendered":"How to get value before decimal point in SQL?"},"content":{"rendered":"<p>To get the value before the decimal point in SQL, you can use the FLOOR function along with CAST or CONVERT. By using these functions, you can extract the integer part of a decimal number.<\/p>\n<p>**SELECT FLOOR(123.45);**<\/p>\n<p>This query will return 123 as the value before the decimal point in the number 123.45.<\/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-before-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-before-decimal-point-in-sql\/#1_How_can_I_get_the_value_before_the_decimal_point_in_SQL_without_rounding_off_the_number\" title=\"1. How can I get the value before the decimal point in SQL without rounding off the number?\">1. How can I get the value before the decimal point in SQL without rounding off the number?<\/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-before-decimal-point-in-sql\/#2_Can_I_use_the_ROUND_function_to_get_the_value_before_the_decimal_point\" title=\"2. Can I use the ROUND function to get the value before the decimal point?\">2. Can I use the ROUND function to get the value before the decimal point?<\/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-before-decimal-point-in-sql\/#3_Is_it_possible_to_get_the_value_before_the_decimal_point_in_SQL_using_SUBSTRING\" title=\"3. Is it possible to get the value before the decimal point in SQL using SUBSTRING?\">3. Is it possible to get the value before the decimal point in SQL using SUBSTRING?<\/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-before-decimal-point-in-sql\/#4_What_is_the_difference_between_FLOOR_and_CEILING_functions_in_SQL\" title=\"4. What is the difference between FLOOR and CEILING functions in SQL?\">4. What is the difference between FLOOR and CEILING functions 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-before-decimal-point-in-sql\/#5_Can_I_get_the_value_before_the_decimal_point_in_SQL_for_negative_numbers\" title=\"5. Can I get the value before the decimal point in SQL for negative numbers?\">5. Can I get the value before the decimal point in SQL for negative numbers?<\/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-before-decimal-point-in-sql\/#6_How_can_I_handle_NULL_values_when_trying_to_get_the_value_before_the_decimal_point_in_SQL\" title=\"6. How can I handle NULL values when trying to get the value before the decimal point in SQL?\">6. How can I handle NULL values when trying to get the value before 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-8\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-value-before-decimal-point-in-sql\/#7_Can_I_perform_arithmetic_operations_on_the_value_before_the_decimal_point_in_SQL\" title=\"7. Can I perform arithmetic operations on the value before the decimal point in SQL?\">7. Can I perform arithmetic operations on the value before 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-9\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-value-before-decimal-point-in-sql\/#8_Is_there_a_way_to_get_the_value_after_the_decimal_point_in_SQL\" title=\"8. Is there a way to get the value after the decimal point in SQL?\">8. Is there a way 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-10\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-value-before-decimal-point-in-sql\/#9_Can_I_convert_the_value_before_the_decimal_point_to_a_string_in_SQL\" title=\"9. Can I convert the value before the decimal point to a string in SQL?\">9. Can I convert the value before the decimal point to a string 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-before-decimal-point-in-sql\/#10_What_happens_if_I_pass_a_non-numeric_value_to_the_FLOOR_function_in_SQL\" title=\"10. What happens if I pass a non-numeric value to the FLOOR function in SQL?\">10. What happens if I pass a non-numeric value to the FLOOR function in SQL?<\/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-before-decimal-point-in-sql\/#11_Is_there_a_way_to_get_the_value_before_the_decimal_point_in_SQL_without_using_any_functions\" title=\"11. Is there a way to get the value before the decimal point in SQL without using any functions?\">11. Is there a way to get the value before the decimal point in SQL without using any functions?<\/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-before-decimal-point-in-sql\/#12_Can_I_get_the_value_before_the_decimal_point_in_SQL_for_a_column_containing_decimal_numbers\" title=\"12. Can I get the value before the decimal point in SQL for a column containing decimal numbers?\">12. Can I get the value before the decimal point in SQL for a column containing decimal numbers?<\/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_How_can_I_get_the_value_before_the_decimal_point_in_SQL_without_rounding_off_the_number\"><\/span>1. How can I get the value before the decimal point in SQL without rounding off the number?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nTo get the value before the decimal point without rounding off, you can use the FLOOR function. It will return the largest integer less than or equal to the specified number.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"2_Can_I_use_the_ROUND_function_to_get_the_value_before_the_decimal_point\"><\/span>2. Can I use the ROUND function to get the value before the decimal point?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nNo, the ROUND function will round the number to the nearest integer. To get the value before the decimal point without rounding, you should use the FLOOR function.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"3_Is_it_possible_to_get_the_value_before_the_decimal_point_in_SQL_using_SUBSTRING\"><\/span>3. Is it possible to get the value before the decimal point in SQL using SUBSTRING?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can use the SUBSTRING function to extract the characters before the decimal point in a string representation of a number. However, it is more efficient to use the FLOOR function for numerical values.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"4_What_is_the_difference_between_FLOOR_and_CEILING_functions_in_SQL\"><\/span>4. What is the difference between FLOOR and CEILING functions in SQL?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nThe FLOOR function returns the largest integer less than or equal to the specified number, while the CEILING function returns the smallest integer greater than or equal to the specified number.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"5_Can_I_get_the_value_before_the_decimal_point_in_SQL_for_negative_numbers\"><\/span>5. Can I get the value before the decimal point in SQL for negative numbers?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can use the FLOOR function for negative numbers as well. It will return the largest integer less than or equal to the specified negative number.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"6_How_can_I_handle_NULL_values_when_trying_to_get_the_value_before_the_decimal_point_in_SQL\"><\/span>6. How can I handle NULL values when trying to get the value before the decimal point in SQL?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYou can use the COALESCE function to handle NULL values. This function returns the first non-null expression among its arguments.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"7_Can_I_perform_arithmetic_operations_on_the_value_before_the_decimal_point_in_SQL\"><\/span>7. Can I perform arithmetic operations on the value before the decimal point in SQL?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, once you have extracted the value before the decimal point using the FLOOR function, you can use it in any arithmetic operation as an integer value.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"8_Is_there_a_way_to_get_the_value_after_the_decimal_point_in_SQL\"><\/span>8. Is there a way to get the value after the decimal point in SQL?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nTo get the value after the decimal point, you can use the MOD function along with the ROUND function to calculate the remainder after division.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"9_Can_I_convert_the_value_before_the_decimal_point_to_a_string_in_SQL\"><\/span>9. Can I convert the value before the decimal point to a string in SQL?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can use the CAST or CONVERT functions to convert the integer value before the decimal point to a string.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"10_What_happens_if_I_pass_a_non-numeric_value_to_the_FLOOR_function_in_SQL\"><\/span>10. What happens if I pass a non-numeric value to the FLOOR function in SQL?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nIf you pass a non-numeric value to the FLOOR function, it will return an error. Make sure to pass only numeric values to the function when trying to extract the value before the decimal point.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"11_Is_there_a_way_to_get_the_value_before_the_decimal_point_in_SQL_without_using_any_functions\"><\/span>11. Is there a way to get the value before the decimal point in SQL without using any functions?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nWhile it is possible to manipulate strings to extract the value before the decimal point without using functions, it is recommended to use the FLOOR function for efficiency and accuracy.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"12_Can_I_get_the_value_before_the_decimal_point_in_SQL_for_a_column_containing_decimal_numbers\"><\/span>12. Can I get the value before the decimal point in SQL for a column containing decimal numbers?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can apply the FLOOR function to a column in a table to extract the value before the decimal point for each row in the column.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>To get the value before the decimal point in SQL, you can use the FLOOR function along with CAST or CONVERT. By using these functions, you can extract the integer part of a decimal number. **SELECT FLOOR(123.45);** This query will return 123 as the value before the decimal point in the number 123.45. FAQs: 1. &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to get value before decimal point in SQL?\" class=\"read-more button\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-value-before-decimal-point-in-sql\/#more-235353\">Read more<span class=\"screen-reader-text\">How to get value before 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-235353","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 before decimal point in SQL?<\/title>\n<meta name=\"description\" content=\"To get the value before the decimal point in SQL, you can use the FLOOR function along with CAST or CONVERT. By using these functions, you can extract the\" \/>\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-before-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 before decimal point in SQL?\" \/>\n<meta property=\"og:description\" content=\"To get the value before the decimal point in SQL, you can use the FLOOR function along with CAST or CONVERT. By using these functions, you can extract the\" \/>\n<meta property=\"og:url\" content=\"https:\/\/namso-gen.co\/blog\/how-to-get-value-before-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-06-20T21:08:40+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-before-decimal-point-in-sql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-get-value-before-decimal-point-in-sql\/\"},\"author\":{\"name\":\"Francis French\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/1622769be52c41a10d83bee2c48a8c48\"},\"headline\":\"How to get value before decimal point in SQL?\",\"datePublished\":\"2024-06-20T21:08:40+00:00\",\"dateModified\":\"2024-06-20T21:08:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-get-value-before-decimal-point-in-sql\/\"},\"wordCount\":578,\"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-before-decimal-point-in-sql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-get-value-before-decimal-point-in-sql\/\",\"url\":\"https:\/\/namso-gen.co\/blog\/how-to-get-value-before-decimal-point-in-sql\/\",\"name\":\"How to get value before decimal point in SQL?\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#website\"},\"datePublished\":\"2024-06-20T21:08:40+00:00\",\"dateModified\":\"2024-06-20T21:08:40+00:00\",\"description\":\"To get the value before the decimal point in SQL, you can use the FLOOR function along with CAST or CONVERT. By using these functions, you can extract the\",\"breadcrumb\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-get-value-before-decimal-point-in-sql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/namso-gen.co\/blog\/how-to-get-value-before-decimal-point-in-sql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-get-value-before-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 before 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 before decimal point in SQL?","description":"To get the value before the decimal point in SQL, you can use the FLOOR function along with CAST or CONVERT. By using these functions, you can extract the","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-before-decimal-point-in-sql\/","og_locale":"en_US","og_type":"article","og_title":"How to get value before decimal point in SQL?","og_description":"To get the value before the decimal point in SQL, you can use the FLOOR function along with CAST or CONVERT. By using these functions, you can extract the","og_url":"https:\/\/namso-gen.co\/blog\/how-to-get-value-before-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-06-20T21:08:40+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-before-decimal-point-in-sql\/#article","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-get-value-before-decimal-point-in-sql\/"},"author":{"name":"Francis French","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/1622769be52c41a10d83bee2c48a8c48"},"headline":"How to get value before decimal point in SQL?","datePublished":"2024-06-20T21:08:40+00:00","dateModified":"2024-06-20T21:08:40+00:00","mainEntityOfPage":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-get-value-before-decimal-point-in-sql\/"},"wordCount":578,"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-before-decimal-point-in-sql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/namso-gen.co\/blog\/how-to-get-value-before-decimal-point-in-sql\/","url":"https:\/\/namso-gen.co\/blog\/how-to-get-value-before-decimal-point-in-sql\/","name":"How to get value before decimal point in SQL?","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/#website"},"datePublished":"2024-06-20T21:08:40+00:00","dateModified":"2024-06-20T21:08:40+00:00","description":"To get the value before the decimal point in SQL, you can use the FLOOR function along with CAST or CONVERT. By using these functions, you can extract the","breadcrumb":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-get-value-before-decimal-point-in-sql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/namso-gen.co\/blog\/how-to-get-value-before-decimal-point-in-sql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/namso-gen.co\/blog\/how-to-get-value-before-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 before 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\/235353","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=235353"}],"version-history":[{"count":0,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts\/235353\/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=235353"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/categories?post=235353"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/tags?post=235353"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}