Equivalent Teradata function for FIX() visual basic function

Tools & Utilities
Enthusiast

Equivalent Teradata function for FIX() visual basic function

Hi,

I am converting VB code to Teradata SP. So, i need equivalent FIX() function in Teradata. Can anyone help me?

Thanks,
Uma Kathir
2 REPLIES
Junior Contributor

Re: Equivalent Teradata function for FIX() visual basic function

Hi Uma,
FIX returns the integer part of a numeric value?

CAST(val AS INT) as long as it fits into an integer

Dieter
Enthusiast

Re: Equivalent Teradata function for FIX() visual basic function

I did not think this way.
Thank you so much, Dieter.

Thanks,
Uma Kathir