Thanks Hans,
Yes, SQLUDR_CHAR can support input/output values as TIMESTAMP. This solves my
problem.
So Trafodion UDF can support TIMESTAMP as both input parameter and output ,
this is great!
Thanks,
Ming
发件人: Hans Zeller [mailto:hans.zel...@esgyn.com]
发送时间: 2016年3月24日 1:34
收件人:
Hi Ming, I think the C data type corresponding to datetime values is
SQLUDR_CHAR. You create a string that looks like "2016-03-23 01:23:45"
(this example is for a TIMESTAMP(0)) and return that. Trafodion will
convert it to the datetime type.
Sorry, I have not tested it but hope it will work.
Hi, all,
I just learned the support of TO_DATE will be avialbe in Trafodion in R2.0 from
Anoop, that is great! At present, due to the urgent requirement of current
migration project, we cannot wait, so I want to write a UDF to do the TO_DATE.
When I try to write it, I found it seems the UDF can