Re: converting INTEGER to CHAR in Trafodion

2016-03-30 Thread Liu, Ming (Ming)
Thanks Anoop for the help again :) Yes, I forgot CAST … 发件人: Anoop Sharma [mailto:anoop.sha...@esgyn.com] 发送时间: 2016年3月30日 22:04 收件人: user@trafodion.incubator.apache.org 主题: RE: converting INTEGER to CHAR in Trafodion Trafodion supports to_date and to_char to convert datetime values from string

converting INTEGER to CHAR in Trafodion

2016-03-30 Thread Liu, Ming (Ming)
Hi, all, I know it will be much easier to do in C or Java after get the result set, but the Oracle users are used to use to_char() function. Is there similar function in Trafodion? Or maybe we can write a UDF for it, but the problem of UDF is it cannot support polymorphism, that is, one can