[R] help needed for strptime "000000" !

[JESSICA]

Hi thanks ! that works perfectly !  now I am wodering how to create a new
table , 

I run the codes: 

x<-read.table("C:/R/DATA.txt",colClasses=c("Date","character","integer"),
header=T)
DateTime<-as.POSIXct(paste(x[,1],x[,2]),format="%Y-%m-%d%H%M%S")

and get :

"2004-11-01 23:33:11 GMT"
"2004-11-01 23:42:27 GMT"
“2004-11-01 23:43:27 GMT”
“2004-11-01 23:47:34 GMT”
“2004-11-02 00:01:57 GMT” 
“2004-11-02 00:02:50 GMT”
“2004-11-02 00:05:23 GMT “
“2004-11-02 00:05:46 GMT “
“2004-11-02 00:05:06 GMT”
“2004-11-02 00:06:49 GMT”
“2004-11-02 00:09:21 GMT”

I want to create a new table which has two columns 

       DateTime                 Q
2004-11-01 23:33:11        1
2004-11-01 23:42:27        1
2004-11-01 23:43:27        1  
2004-11-01 23:47:34        2
2004-11-02 00:01:57        3
2004-11-02 00:02:50        10
2004-11-02 00:05:23        16
2004-11-02 00:05:46        1
2004-11-02 00:05:06        2
2004-11-02 00:06:49        1
2004-11-02 00:09:21        3

I tried  cbind(DateTime,x$Q) , but it failed , I know it is a little stupid
question but I still can not figure out how to get a new table like above. 

Any help would be greatly appreciated ! 
-- 
View this message in context: http://r.789695.n4.nabble.com/help-needed-for-strptime-000000-tp3309588p3310240.html
Sent from the R help mailing list archive at Nabble.com.