Ivan have add into Valentina engine new very powerful FORMAT() function for SQL.
It provides great ability to convert numbers and date/times into string format.
Please read detailed syntax in the Valentina WIKI:
http://valentina-db.com/dokuwiki/doku.php?id=valentina:vcomponents:vsql:reference:expr:funcs_string#format
The same algorithms will be added in nearest time to Valentina Reports.