[R] Question on creating Date variable

arun smartpink111 at yahoo.com
Mon Dec 31 18:44:41 CET 2012


Hi,
Try this:
x<-c(11.00,11.25,11.35,12.01,11.14,13.00,13.25,13.35,14.01,13.14,14.50,14.75,14.85,15.51,14.64)
 x[substr(x,4,5)>=60]<-(x[substr(x,4,5)>=60]-.60)+1
 res<-sort(as.POSIXct(paste("2012-12-31", sprintf("%.2f",x),sep=" "),format="%Y-%m-%d %H.%M")) #
 ifelse(format(res,"%H:%M")>=12, paste(res,"PM"), paste(res,"AM"))
# [1] "2012-12-31 11:00:00 AM" "2012-12-31 11:14:00 AM" "2012-12-31 11:25:00 AM"
 #[4] "2012-12-31 11:35:00 AM" "2012-12-31 12:01:00 PM" "2012-12-31 13:00:00 PM"
 #[7] "2012-12-31 13:14:00 PM" "2012-12-31 13:25:00 PM" "2012-12-31 13:35:00 PM"
#[10] "2012-12-31 14:01:00 PM" "2012-12-31 14:50:00 PM" "2012-12-31 15:04:00 PM"
#[13] "2012-12-31 15:15:00 PM" "2012-12-31 15:25:00 PM" "2012-12-31 15:51:00 PM"
str(ifelse(format(res,"%H:%M")>=12, paste(res,"PM"), paste(res,"AM")))
 #chr [1:15] "2012-12-31 11:00:00 AM" "2012-12-31 11:14:00 AM" ...
str(res)
# POSIXct[1:15], format: "2012-12-31 11:00:00" "2012-12-31 11:14:00" ...


 
A.K.



----- Original Message -----
From: Christofer Bogaso <bogaso.christofer at gmail.com>
To: r-help at r-project.org
Cc: 
Sent: Monday, December 31, 2012 12:12 PM
Subject: [R] Question on creating Date variable

Hello all,

Let say I have following (numeric) vector:

> x
[1] 11.00 11.25 11.35 12.01 11.14 13.00 13.25 13.35 14.01 13.14 14.50 14.75 14.85 15.51 14.64

Now, I want to create a 'Date' variable (i.e. I should be able to do all calculations pertaining to date/time and also time-series plotting etc.) like

2012-12-31 11:00:00 AM, 2012-12-31 11:25:00 AM, 2012-12-31 11:35:00 AM, 2012-12-31 12:01:00 PM, . . . .


Is it possible to achieve that?

Thanks and regards,

______________________________________________
R-help at r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.





More information about the R-help mailing list