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 only define the syntax/signature of a UDF once, is it true? For example, it cannot define a TO_CHAR that can : TO_CHAR(123), return is '123'. TO_CHAR(date'2001/11/11','YYYY/MM/DD'), return is '2001-11-11'. Seems rather difficult to replace Oracle's TO_CHAR completely. Or I miss something? Thanks in advance. Thanks, Ming
