 |
 |
Archives of the TeradataForum
Message Posted: Tue, 21 Apr 2015 @ 16:48:45 GMT
| Subj: | | Re: UDF Error - Function does not exist |
| |
| From: | | Dieter Noeth |
Roopalini Bakthavachalam wrote:
| | I figured it out. I casted the date1, date2 and date3 to VARCHAR and it worked:-) | |
Yep, this is stupid, both LEAST and GREATEST don't work on dates. Of course this is the first thing I was trying to do and I failed, too :-)
But I prefer CASTing to INT instead of VarChar.
Btw, later TD releases return a more meaningful error message:
[9881] Function 'LEAST' called with an invalid number or type of parameters
Dieter
| |
