Unrecognised function 'ceil'

[#1]

Hi all,

I am writing a script like: ceil(month(Date)/3) as Purchase_Quarter and getting an error as 'unrecognised built in function  'ceil''.

Please help.

Thanks,

Madhura

[#2]

Sunny, you were right, may be SQL does not recognise ceil function. But, if I load the quarter seperately like you showed, it does not select the other fields from SQl select statement.

[sunny_talwar]

When you use * (asterisk) in your preceding load you get all your fields from the below table.

[sunny_talwar]

Or use CEILING as proposed by Sasidhar Parupudi

[#5]

Thanks Sasidhar, that worked as I wanted.