Need to fetch integer part from decimal data

HemaV · Post by **HemaV** » Thu Sep 05, 2013 7:36 am

my source data contains value as "1234.56" which is of decimal(17,2) datatype.

In my target table:
i want only the integer part of above value appended with zeroes at the starting for varchar2(16) datatype.
in target value needed is "0000000000001234"

Please let me know what function can be used to take only integer value without dot.

Thanks in advance,

chulett · Post by **chulett** » Thu Sep 05, 2013 7:40 am

Floor()

HemaV · Post by **HemaV** » Thu Sep 05, 2013 8:21 am

Will the Floor() function round up if the value after decimal point is greater than 5?

IBM Analytics Champion 2009 - 2020 · Post by **asorrell** » Thu Sep 05, 2013 8:32 am

No.

From the Parallel Job Developer's Guide

Floor Calculates the largest integer value less than or equal to the given decimal value.
- Input: number (dfloat)
- Output: result (int32)

chulett · Post by **chulett** » Thu Sep 05, 2013 10:47 am

As noted, no since that's not what you asked for... and a quick check of the documentation would have answered your question. If you ever need that functionality, the Ceil() function would be appropriate.

SURA · Post by **SURA** » Thu Sep 05, 2013 6:09 pm

HemaV wrote:target value needed is "0000000000001234"

Please let me know what function can be used to take only integer value without dot.

Thanks in advance,

Why can't you use

Code: Select all


Field(in.source,'.',1)

ray.wurlod · Post by **ray.wurlod** » Thu Sep 05, 2013 6:40 pm

A curious suggestion from someone who has "performance driven outcomes" in his signature block!

How many data type conversions (implicit or otherwise) does your "solution" require?

SURA · Post by **SURA** » Thu Sep 05, 2013 6:51 pm

Ray

Nothing to do with signature:)

Its all about providing the number of ways things can be handled and the poster will get an idea about handling the ways!!

I do failed to add a point at the time when i post my comment as "Ugly way"

But you are our DS guru and i am in the same page with your comment.

HemaV · Post by **HemaV** » Fri Sep 06, 2013 1:36 am

when i tried with AsInteger(lnk.col1) then it removed decimal point and decimal part values.

Thanks in Advance,

priyadarshikunal · Post by **priyadarshikunal** » Fri Sep 06, 2013 5:16 am

HemaV wrote:when i tried with AsInteger(lnk.col1) then it removed decimal point and decimal part values.

Did that retained 0's in the in the output as you wanted in the first post?

ray.wurlod · Post by **ray.wurlod** » Fri Sep 06, 2013 7:20 pm

HemaV wrote:when i tried with AsInteger(lnk.col1) then it removed decimal point and decimal part values.

Isn't that what you wanted?

DSXchange

Need to fetch integer part from decimal data

Need to fetch integer part from decimal data

Re: Need to fetch integer part from decimal data