Search results
16 lis 2017 · You need to cast to a decimal that can hold the value of 5666.232343. DECIMAL(7,5) allows numbers in this format: ##.#####. The biggest number you can have then is 99.99999. You also need to take the comma out and replace it with a period: SELECT CAST('5666.232343' as decimal(16,6)) AS [DecimalValue]
19 cze 2012 · SELECT CONVERT (decimal (11,2), REPLACE ('6.999,50', '.', '')) will yield 6999,50 as a decimal. You are going to have to truncate the values yourself as strings before you put them into that column. Otherwise, if you want more decimal places, you will need to change your declaration of the decimal column.
Learn how to use the CONVERT () function to convert a value to a specified datatype, such as decimal, in SQL Server. See syntax, parameters, examples and tips for different data types and formats.
23 maj 2023 · Reference for the CAST and CONVERT Transact-SQL functions. These functions convert expressions from one data type to another.
16 wrz 2021 · Learn how to convert SQL Server data to different data types such as string, date, integer and numeric using the CAST and CONVERT functions.
This example uses the TRY_CONVERT () function to convert a string to decimal: SELECTTRY_CONVERT(DECIMAL(4,2), '12.34'); Code language:SQL (Structured Query Language)(sql) Here is the result: Result ---------- 12.34 Code language:SQL (Structured Query Language)(sql) The following shows another example:
C) Using TRY_CAST () function to CAST string to decimal examples.
