Getting trailing zeroes

[Manjunathps]

Hi All,

I am doing a Full load from Oracle to KINESIS stream, in the date columns for a particular table, I am getting the extra 9 zeroes at the target in timestamp. the data type is DATETIME(0)

Ex: Oracle source : 08-02-2023 14:12:56 at the target it is: 08-02-2023 14:12:56.000000000

Any quick resolution is highly appreciated.

Thank you

[SachinB · Accepted solution]

Hello @Manjunathps ,

Thank you for reaching out to the Qlik community!

Could you please try adding the global transformation as convert data type? And let us know the results for the same.

Regards,

Sachin  B

[Manjunathps]

Hi @SachinB ,

I will check this and let you know.

Thank you,

Manjunath

[Rishel]

Consider applying a transformation to the datetime columns before they are loaded into the Kinesis stream. You can format the datetime values to match the desired format (without the additional zeroes) using Oracle's formatting functions.