mysql select int as currency or convert int to currency format?

How to convert currency in MySQL?

Select int as currency or convert int to currency format in MySql? To convert int to current format, use CONCAT() with FORMAT() function from MySQL.

How do I add a currency symbol in SQL?

you need to cast it because you are concatenating a string into a decimal data type. If you are working on it on the application level, you can add extra column which is not processed, ex. SELECT PayerDate, '$' + CAST(PaymentAmount AS VARCHAR(15)) StrPaymentAmount, PaymentAmount FROM Payments .

FORMAT() function: http://dev.mysql.com/doc/refman/5.5/en/string-functions.html#function_format

SELECT CONCAT('$', FORMAT(val, 2)) ... ;

Related questions

Mysql covering vs composite vs column index

Best practice to record large amount of hits into MySQL database

MySQL, create a simple function [closed]

SELECT that returns list of values not occurring in any row

How do you refresh the MySQL configuration file without restarting?

$PATH not being saved after I leave terminal

How to do Inheritance Modeling in Relational Databases?

SQLSTATE[HY093]: Invalid parameter number: parameter was not defined

Difference between utf8mb4_unicode_ci and utf8mb4_unicode_520_ci collations in MariaDB/MySQL?

How do I concatenate strings from a subquery into a single row in mysql?

Query to determine the size of tables in a database? (mysql)

SQL UPDATE with sub-query that references the same table in MySQL

How to install MySQLdb package? (ImportError: No module named setuptools)

MySQL: Select Random Entry, but Weight Towards Certain Entries

Mysql Color Scheme

Fire a trigger after the update of specific columns in MySQL

How do I check if PHP is connected to a database already?

Simulate lag function in MySQL

How do I turn off autocommit for a MySQL client?

SQLAlchemy ON DUPLICATE KEY UPDATE

mysql select int as currency or convert int to currency format?

Tags:

mysql

People also ask

Recent Activity

Donate For Us