Solved: 8 Digits in Millisecond - Timestamp column

[biusercog]

Hello All

We are bringing in a timestamp column ('CCYY-MM-DD HH:MM:SS.F8') from a view in FM. We are using Netezza db. I need to show date in 8 digit millisecond format 'CCYY-MM-DD HH:MM:SS.F8'. In RS, When I pull this column into filter and check data, I see 8 digits in milliseconds but when I use this in report, I see only 3 digits in milliseconds 'CCYY-MM-DD HH:MM:SS.F3'.

I tried multiple things(converting to char, varchar etc) and changed the format in FM to show milliseconds but maximum I see in RS is 3 digits. Not sure what am I missing here. How can I show 8 digit milliseconds in RS?

Thanks

[biusercog]

Had syntax error in my statement earlier, found solution in another site. Posting it here as it might be helpful for someone.

TO_CHAR([TIMESTAMP], 'YYYY-MM-DD HH24:MI:SS.MSSSSSSS')

In Milliseconds syntax, each 'S' represents one digit.

https://www.ibm.com/support/knowledgecenter/en/SSULQD_7.2.1/com.ibm.nz.dbu.doc/r_dbuser_ntz_sql_extns_templ_patterns_date_time_conv.html