CEIL and FLOOR functions

General
Enthusiast

CEIL and FLOOR functions

Hi,

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 ?

Thanks.

2 REPLIES
Junior Supporter

Re: CEIL and FLOOR functions

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)

Cheers.

Carlos.

Enthusiast

Re: CEIL and FLOOR functions

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.