Bug 3509

Summary: add support for formatted conversion to string using function: to_char(num_ts_val, 'format_mask')
Product: SQL Reporter: Martin van Dinther <martin.van.dinther>
Component: allAssignee: SQL devs <bugs-sql>
Status: NEW ---    
Severity: enhancement    
Priority: Normal    
Version: -- development   
Hardware: Other   
OS: Linux   

Description Martin van Dinther cwiconfidential 2014-07-04 17:47:54 CEST
User-Agent:       Mozilla/5.0 (X11; Linux x86_64; rv:30.0) Gecko/20100101 Firefox/30.0
Build Identifier: 

MonetDB currently does not support conversions of numeric or date or timestamp data to a string in a specific layout format, as is possible with to_char(num_ts_val, 'format_mask')
See also:
http://www.postgresql.org/docs/9.3/interactive/functions-formatting.html
and
http://www.techonthenet.com/oracle/functions/to_char.php


Reproducible: Always




tests for to_char() are already defined in
 sql/test/pg_regress/sql/in8.sql
 sql/test/pg_regress/sql/numeric.sql
 sql/test/pg_regress/sql/timestamp.sql
 sql/test/pg_regress/sql/timestamptz.sql
but they currently all produce errors as the to_char() is not supported.