CODEWITHSUNDEEP
sqlmysql
Jaime
Jaime

Reputation:

format integer to string

I have an integer field in a table and I want to make a query to format the integer value of this field in an char or double field with a especific format.

For example, if my value in the table is 123456 I want to format it as "###.###" what means the result should be like this: 123.456

I've done this using CONCAT function, but the result is not very elegant. I would like to use another funciont spacific for this purpose.

Upvotes: 0

Views: 444

Answers (2)

Pavlo Svirin
Pavlo Svirin

Reputation: 508

Maybe you would like to use formatting like '###,###.###' ?

Here is the example.

mysql> select FORMAT( 123446, 4 );

+---------------------+

| FORMAT( 123446, 4 ) |

+---------------------+

| 123,446.0000 |

+---------------------+

1 row in set (0.02 sec)

mysql> select FORMAT( 123446, 0 );

+---------------------+

| FORMAT( 123446, 0 ) |

+---------------------+

| 123,446 |

+---------------------+

1 row in set (0.00 sec)

Upvotes: 0

badbod99
badbod99

Reputation: 7526

I would suggest doing this in your presentation layer rather than the DB.

This is pretty easy in C#:

// Assuming value is an int
value.ToString("N");

More details on formatting int in various ways see the Microsoft documentation

Upvotes: 1

Related Questions