comma sepator for thousands

[rimages]

Hi

Just wondering if it possible with MYSQL to make numeric values show number that is uses comma to separate thousands.

example: 1000
1,000 - with sql code

In oracle I can use to_num syntax, but no idea how to do it in MySQL.

Thanks


Roman

[mordred]

Have you looked at FORMAT()?

http://www.mysql.com/doc/en/Miscellaneous_functions.html

[rimages]

DATE_FORMAT

Thank you.

Is there a similar format for date formating.

example:

date_format(datefield, F dS Y) ?

thanks

Roman

[mordred]

Indeed there is a function and guess what - it goes by the name you said: DATE_FORMAT():

http://www.mysql.com/doc/en/Date_and_time_functions.html