All Forums General
KS42982 137 posts Joined 12/12
03 Apr 2013
CEIL and FLOOR functions

I am trying to use CEIL and FLOOR functions of teradata in TD13 and TD14 as we have migrated to TD14 in DEV and QA but still at TD13 in PROD. Somehow, these functions work fine in TD14, but givesĀ an error when I try to use in TD13.
For example, if I do as simple as - SELECT CEIL(4.5) in TD13, it gives error saying -- expected something between '(' and '4.5'.
Does anyone else face the similar issue with TD13 or it's just our envionment over here ?

CarlosAL 512 posts Joined 04/08
03 Apr 2013

This functions are two of the new ones in TD14, (the all-new "Embedded Services System Functions") AFAIK there is no CEIL or FLOOR functions in TD13 (unless you code them in C as UDFs)

KS42982 137 posts Joined 12/12
03 Apr 2013

Oh k. I thought teradata introduced it in TD13. When I write a SQL usingĀ these in TD13 sql assitant, it turns BLUE (like any teradata function), so I thought its already there but not working. Anyways, thanks for the clarification.

You must sign in to leave a comment.