[R] formating chron date times for printing

Gabor Grothendieck ggrothendieck at gmail.com
Tue Jun 29 20:39:58 CEST 2010


On Tue, Jun 29, 2010 at 2:22 PM, Gabor Grothendieck
<ggrothendieck at gmail.com> wrote:
> On Tue, Jun 29, 2010 at 2:01 PM, stephen sefick <ssefick at gmail.com> wrote:
>> the date were created with chron with this argument
>>
>> format=c(dates="Y/m/d", times="H:M:S"))
>>
>> so I have the dates being displayed as
>>
>> (10/06/22 12:00:00)
>>
>> I would like to have them displayed as
>>
>> "2010-06-22 12:00:00" or "%Y-%m-%d %H:%M:%S"
>>
>> and then I can convert these for mergeing with another data frame
>>
>> x <- (structure(c(14464, 14464.0104166667, 14464.0208333333, 14464.03125,
>> 14464.0416666667), format = structure(c("Y/m/d", "H:M:S"), .Names = c("dates",
>> "times")), origin = c(1, 1, 1970), class = c("chron", "dates",
>> "times")))
>>
>> reading through old posts I found this:
>>
>> format(x, enclosed = c("", ""))
>>
>> which put the which surrounds the date time with "" instead of ()
>> now I would like to change the format of the dates to print like the
>> above specified.
>> kindest regards,
>>
>
> Try this:
>
>> format(as.POSIXlt(x, tz = "GMT"))
> [1] "2009-08-08 00:00:00" "2009-08-08 00:15:00" "2009-08-08 00:29:59"
> [4] "2009-08-08 00:45:00" "2009-08-08 01:00:00"
>

Also here is another solution:

> paste(as.Date(x), format(x - floor(x)))
[1] "2009-08-08 00:00:00" "2009-08-08 00:15:00" "2009-08-08 00:30:00"
[4] "2009-08-08 00:45:00" "2009-08-08 01:00:00"



More information about the R-help mailing list