seconds past midnight

[hawley]

I have a select statement that is bringing back date values. The problem is I want it in a db2 format. I know how to get the extra seconds past midnight but I need one more zero added on. Does anyone know a way to add an extra 0 to the end?

Here is my select statement:
SELECT DISTINCT
TO_CHAR(strt_tmst, 'YYYY-MM-DD-HH24.MI.SS.SSSSS')
FROM pmt_promo

Here is what is returned:
2003-07-21-00.00.00.00000
Here is what I want to get:
2003-07-21-00.00.00.000000

 

[markrem]

SELECT DISTINCT
TO_CHAR(strt_tmst, 'YYYY-MM-DD-HH24.MI.SS.SSSSS')||'0'
FROM pmt_promo;

 

[hawley]

Thank you very much. Figures it was something that simple.