search for: mydatetime

Hello all, I don' like to have ( ) around my datetime, when send the csv file to somebody. How to remove it? >library(chron) >mydate <- c("2009-05-03","2009-06-07") >mytime <- c("10:30:00","10:20:00") >mydatetime <- chron(dates=mydate,times=mytime,format=c("y-m-d","h:m:s")) >write.csv(mydatetime)   "","x" "1",(09-05-03 10:30:00) "2",(09-06-07 10:20:00)   thanks! Jeff [[alternative HTML version deleted]]

...1,at=c(0,100),line=1) >> >> As you say you have date/time values, you will have to extract the >> time values from the date/times. If all you want is something like the >> hours as in the above example, you can just do this: >> >> mydata$hours<-format(strptime(mydatetimes,<date time format>),"%H") >> hour_freq<-as.vector(table(mydata$hours)) >> >> I am assuming that you want some sort of frequency distribution during >> the day. If I have misunderstood, please let me know. >> >> Jim >> >> On Fri, Ap...

R HELP, I am trying to use an R script to connect to a mysql database. I am having a problem using a variable in the where clause that contains a "space" in its value. If I include the variable inside the quotes of the query - i think it is searching for the name of the variable in the database and not the value of the variable. If I put it outside the quotes, then it complains

...m> Content-Type: text/plain Hello all, I don' like to have ( ) around my datetime, when send the csv file to somebody. How to remove it? >library(chron) >mydate <- c("2009-05-03","2009-06-07") >mytime <- c("10:30:00","10:20:00") >mydatetime <- chron(dates=mydate,times=mytime,format=c("y-m-d","h:m:s")) >write.csv(mydatetime) ? "","x" "1",(09-05-03 10:30:00) "2",(09-06-07 10:20:00) ? thanks! Jeff [[alternative HTML version deleted]] -------------------------...