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
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 (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)