Truncate a decimal field without rounding

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

Truncate a decimal field without rounding

Rate Topic

Display Mode

Topic Options

Author

Message

Sujatha

Posted 6/9/2008 3:18:48 AM

Forum Newbie

Group: Forum Members
Last Login: 6/11/2008 8:15:47 AM
Posts: 6, Visits: 27

Example: 123.4567 i want to change/convert it to 123.45 and not 123.46.

Please suggest some solution.

Post #11760

Adeel.Chaudhry

Posted 6/9/2008 3:25:21 AM

Supreme Being

Group: Forum Members
Last Login: Yesterday @ 7:51:48 AM
Posts: 159, Visits: 457

Hello,

You can use double casting...and INDEX function as below:

SELECT SUBSTR(CAST('123.4567' AS VARCHAR(10)), 1, INDEX('123.4567', '.')+2)

HTH.

Regards,

Adeel

Post #11761

CarlosAL

Posted 6/9/2008 4:27:56 AM

Junior Member

Group: Forum Members
Last Login: 8/29/2008 6:03:37 AM
Posts: 10, Visits: 166

CAST is your friend:

[font=Courier New]
select cast(cast((123.4567 * 100) as integer) as numeric (9,2)) /100;

*** Query completed. One row found. One column returned.
*** Total elapsed time was 1 second.

((123.4567*100)/100)
--------------------
123.45

BTEQ -- Enter your DBC/SQL request or BTEQ command:
[/font]

HTH

Cheers.

Carlos.

Post #11764