Re: st: RE: Converting date/clock format to date format?

[Miranda Kim <mk@mrc.soton.ac.uk>]

Thanks a lot for this. I also have some date variables that do not have 
any format and are stored as 'long'. How does one know what format was 
used and how to convert them in this case? Would one need to try all 
possible cases?
Thanks for your help

Nick Cox wrote:
> You are correct. This is a basic question that can be answered by
> reading the help. In addition to Martin Weiss' answers, the function
> -dofc()- may be what you need. 
>
> Nick 
> n.j.cox@durham.ac.uk 
>
> Miranda Kim
>
> I want to merge two datasets together that both have a 'datereturn' 
> variable.
> They have different formats however. In one it is a %tc and in the other
>
> %dD_m_Y.
> Where it is %tc format I cannot convert it to a date format...
> If I type
> format datereturn %dD_m_Y
> It displays: 1478563200000
> I know this is probably very basic, bu I'd be very grateful for some
> help...
>
> *
> *   For searches and help try:
> *   http://www.stata.com/help.cgi?search
> *   http://www.stata.com/support/statalist/faq
> *   http://www.ats.ucla.edu/stat/stata/
>
>
>   

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/