Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: ISO 8601 date-time format in Stata 10


From   Robert A Yaffee <bob.yaffee@nyu.edu>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: ISO 8601 date-time format in Stata 10
Date   Wed, 22 Aug 2007 12:30:12 -0400

Dear Joe,
   You can use the substr  function to extract the date and time into separate string variables.
Use ssc install catenate
then you can construct a new datetime variable  such as  mydt = catenate datestr + timestr)
   Then use transform this into a Stata date time function with    gen double statadt = clock(mydt, "YMD hms")
Then format this with the new   format statdt %tc

    You will have solved your problem.
           Regards,
                  Bob Yaffee


Robert A. Yaffee, Ph.D.
Research Professor
Shirley M. Ehrenkranz
School of Social Work
New York University

home address:
Apt 19-W
2100 Linwood Ave.
Fort Lee, NJ
07024-3171
Phone: 201-242-3824
Fax: 201-242-3825
yaffee@nyu.edu
homepage: http://homepages.nyu.edu/~ray1/

----- Original Message -----
From: Joseph Coveney <jcoveney@bigplanet.com>
Date: Wednesday, August 22, 2007 11:20 am
Subject: st: ISO 8601 date-time format in Stata 10
To: Statalist <statalist@hsphsun2.harvard.edu>


> Could someone show what the format statement is in order to get the
> following date-time format for a double-precision variable containing 
> a 
> timestamp?
> 
> 2007-08-22T23:54:00
> 
> I've read the help file for dates and times, but am unable to use the 
> new 
> syntax correctly.
> 
> Joseph Coveney
> 
> 
> *
> *   For searches and help try:
> *   http://www.stata.com/support/faqs/res/findit.html
> *   http://www.stata.com/support/statalist/faq
> *   http://www.ats.ucla.edu/stat/stata/
*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index