Hello All,

Currently the HCNVRT function coded below :
TX_TS_O/A26 = HCNVRT(TX_TS,'(HYYMDm)', 26, 'A26');

Yields this output format:
2010/03/01 14:44:07.000000

I need the output field in this format:
2010-03-01-14.44.07.000000

Is this doable using HCNVRT?

Thanks to all

This message has been edited. Last edited by: Kerry,

My system info is
Z/OS
Focus 765

Try this,

TX_TS_O/A26 = EDIT(HCNVRT(TX_TS,'(HYYMDm)', 26, 'A26'),'9999-99-99-99.99.99.999999');

Hope this helps.

quote:

TX_TS_O/A26 = EDIT(HCNVRT(TX_TS,'(HYYMDm)', 26, 'A26'),'9999-99-99-99.99.99.999999');

Should the EDIT mask not read '9999$-99$-99$-99$.99$.99$.999999'? The $ sign skips the part that you do not need...

[SOLVED]
'9999$-99$-99$-99$.99$.99$.999999' did the trick.

Thanks to all!