Changing time format

[Hulya Kocyigit]

Hello,

I would like to change the format of a date variable, timestamp. Its current format is 20180201032049. I want to change it to YYYY MM DD HH MM SS. So I use the code

format timestamp %tcCCYYNNDDHHMMSS.

This code turns 20180201032049 into 25990626032352. Can anyone see what I am doing wrong?

Kind regards,,
Hulya Kocyigit

[Hemanshu Kumar]

This is a duplicate of this discussion:

https://www.statalist.org/forums/for...ng-time-format

Please follow the discussion there.