Bug 3509 - add support for formatted conversion to string using function: to_char(num_ts_val, 'format_mask')
Summary: add support for formatted conversion to string using function: to_char(num_ts...
Status: NEW
Alias: None
Product: SQL
Classification: Unclassified
Component: all (show other bugs)
Version: -- development
Hardware: Other Linux
: Normal enhancement
Assignee: SQL devs
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-07-04 17:47 CEST by Martin van Dinther
Modified: 2016-04-11 11:46 CEST (History)
0 users



Attachments

Note You need to log in before you can comment on or make changes to this bug.
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.