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 <[email protected]>
To   [email protected]
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
[email protected]
homepage: http://homepages.nyu.edu/~ray1/

----- Original Message -----
From: Joseph Coveney <[email protected]>
Date: Wednesday, August 22, 2007 11:20 am
Subject: st: ISO 8601 date-time format in Stata 10
To: Statalist <[email protected]>


> 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–2024 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index