Replace str in expression

I am using localtimestamp format in expression transformation

Suppose my date is 30-oct-21 12.06.50.666340700 AM

In informatica, expression transformation, Output should be 12065066 like HHMISSMS without any colon Or spaces.

1 answer

  • answered 2021-10-31 18:42 Koushik Roy

    Can you pls use this to capture milliseconds.

    To_char(datetime_col,'HH24MISSMS')
    

    Output should be like 12065066.

How many English words
do you know?
Test your English vocabulary size, and measure
how many words do you know
Online Test
Powered by Examplum