When the days and time are identical, difftime() gives difference in secs. I still want difference in days.
Say, below my last row is identical dat3<-read.table(text=" Begin_date End_date 01JAN2000:00:00:00:000 02FEB2002:00:00:00:000 24MAR2012:00:00:00:000 18MAY2012:00:00:00:000 01OCT2003:00:00:00:000 02FEB2004:00:00:00:000 01JAN2000:00:00:00:000 02FEB2000:00:00:00:000 01JAN2000:00:00:00:000 02FEB2000:00:00:00:000 24DEC2012:00:00:00:000 24DEC2012:00:00:00:000 ",sep="",header=TRUE) -M On Tue, Jul 10, 2012 at 1:52 PM, arun <smartpink...@yahoo.com> wrote: > Hi, > > Try this: > > dat3<-read.table(text=" > Begin_date End_date > 01JAN2000:00:00:00:000 02FEB2002:00:00:00:000 > 24MAR2012:00:00:00:000 18MAY2012:00:00:00:000 > 01OCT2003:00:00:00:000 02FEB2004:00:00:00:000 > 01JAN2000:00:00:00:000 02FEB2000:00:00:00:000 > 01JAN2000:00:00:00:000 02FEB2000:00:00:00:000 > ",sep="",header=TRUE) > > dat3$Begin_date<-strptime(dat3[,1],format="%d%b%Y:%H:%M:%S") > dat3$End_date<-strptime(dat3[,2],format="%d%b%Y:%H:%M:%S") > > difftime(dat3[,1],dat3[,2]) > Time differences in days > [1] -763.0000 -55.0000 -124.0417 -32.0000 -32.0000 > attr(,"tzone") > [1] "" > > A.K. > > ----- Original Message ----- > From: C W <tmrs...@gmail.com> > To: r-help <r-help@r-project.org> > Cc: > Sent: Tuesday, July 10, 2012 1:22 PM > Subject: [R] calculating the difference between days? > > Hi List, > > I have one column of beginning dates and one column of ending dates, I want > to find their difference. And I want to ignore the trailing zeros, > basically everything after the first colon mark. > > Begin_date End_date > 01JAN2000:00:00:00:000 02FEB2002:00:00:00:000 > 24MAR2012:00:00:00:000 18MAY2012:00:00:00:000 > 01OCT2003:00:00:00:000 02FEB2004:00:00:00:000 > 01JAN2000:00:00:00:000 02FEB2000:00:00:00:000 > 01JAN2000:00:00:00:000 02FEB2000:00:00:00:000 > > Thanks, > > Mike > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help@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. > > [[alternative HTML version deleted]] ______________________________________________ R-help@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.
