SQL Numeric conversion

Printable View

October 8th, 2020, 10:23 AM
James West

SQL Numeric conversion

Hi,

I have got some problems when running this SQL statement :

select CONVERT(numeric,0x120200000000084e20e90015)

It shows "Erreur de conversion du type de données varbinary en numeric.".

How could I manage to fix that point ?

Thank you for help !
October 8th, 2020, 12:54 PM
Arjay

Re: SQL Numeric conversion

Have you tried to single quote the binary string?
October 8th, 2020, 01:17 PM
James West

Re: SQL Numeric conversion

Quote:

Originally Posted by Arjay

Have you tried to single quote the binary string?

Hi Arjay,

Do you mean something like this : select CONVERT(numeric,'0x120200000000084e20e90015') ?

If so, it does not work. It gives an error ==> Erreur de conversion du type de données varchar en numeric.
October 8th, 2020, 01:23 PM
VictorN

Re: SQL Numeric conversion

Quote:

Originally Posted by James West

Hi Arjay,
Do you mean something like this : select CONVERT(numeric,'0x120200000000084e20e90015') ?
If so, it does not work. It gives an error ==> Erreur de conversion du type de données varchar en numeric.

Well, but you were going to convert it to numeric, not to datetime!

Quote:

Originally Posted by James West

Hi,

I have got some problems when running this SQL statement :

select CONVERT(numeric,0x120200000000084e20e90015)

Weren't you?
October 8th, 2020, 01:28 PM
James West

Re: SQL Numeric conversion

Quote:

Originally Posted by VictorN

Well, but you were going to convert it to numeric, not to datetime!

Weren't you?

It was an error .

I have posted two threads in this way and one is related also to date conversion.
October 8th, 2020, 02:26 PM
VictorN

Re: SQL Numeric conversion

Quote:

Originally Posted by James West

It was an error .

I have posted two threads in this way and one is related also to date conversion.

So did it work with numeric?
October 9th, 2020, 07:16 AM
mikeduke1290

Re: SQL Numeric conversion

The process of changing data type of a value into another data type is referred to as data type conversion and also almost all programing languages include some type of data converting functions or functionality. When we turn our perspective to SQL Server in order to discuss details of SQL data converting operations, at first we can separate data conversion process into two parts; implicit and explicit conversions. Implicit conversion is done by SQL Server for internal needs and you can also find additional details in the article Implicit conversion in SQL Server. Explicit conversion is performed explicitly by a database programmer or administrator and at the same time this conversion process is made with help of any data conversion function. In this article, we will particularly focus on the SQL CONVERT function. This function provides a means to convert one data type to another specified data type. At first, we will interpret the syntax of the SQL CONVERT function.
October 9th, 2020, 07:25 AM
VictorN

Re: SQL Numeric conversion

Quote:

Originally Posted by mikeduke1290

The process of changing data type of a value into another data type is referred to as data type conversion and also almost all programing languages include some type of data converting functions or functionality.
...
At first, we will interpret the syntax of the SQL CONVERT function.

Is this quotation from https://www.sqlshack.com/sql-convert-function/ ?
Or what were you going to say? :confused:
October 9th, 2020, 11:57 AM
2kaud

Re: SQL Numeric conversion

Quote:

Originally Posted by VictorN

Is this quotation from https://www.sqlshack.com/sql-convert-function/ ?
Or what were you going to say? :confused:

I'd say it's a copy-and-paste hijack!