答复: How to implement a TO_DATE UDF in Trafodion

2016-03-23 Thread Liu, Ming (Ming)
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 收件人:

Re: How to implement a TO_DATE UDF in Trafodion

2016-03-23 Thread Hans Zeller
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.