changing the date format

[Buyadaa Oyunchimeg]

Dear Stata users,

I wonder how to change the string date (for example 2012-12-17) variable into YYYY/MM/DD 00:00:00 (2012-12-17 00:00:00) format.

Any help would be appreciated.

Many thanks,

Oyun

[Ken Chui]

generate double wanted = clock(your_date_variable, "YMD")
format wanted %tcCCYY/NN/DD_HH:MM:SS

See example 7 on page 5: https://www.stata.com/manuals/ddatetime.pdf

[Buyadaa Oyunchimeg]

Thanks very much!