Ohh ... Thanks Gabor. I have a few related queries then, kindly have a look:
1. Does it only hinder the sqldf package or are there other issues with using POSIXlt in a dataframe? Am asking because I have a few dataframes with columns of class(POSIXlt ). 2. I have columns containing 'date+timestamp', something like '2011-01-03 09:07:07' which are of class POSIXlt. I need to perform some arithmetic operations on these columns. Which class would be most appropriate for such kind of data? Thanks and Regards, Shivam On Thu, May 10, 2012 at 4:45 AM, Gabor Grothendieck <ggrothendi...@gmail.com > wrote: > On Wed, May 9, 2012 at 5:58 PM, Shivam <shivamsi...@gmail.com> wrote: > > Hi All, > > > > I am having trouble executing SQL statements on a few dataframes, but the > > funny thing is that I am able to execute the statement on some other > > dataframes. > > > > Never put POSIXlt objects into data frames. > > -- > Statistics & Software Consulting > GKX Group, GKX Associates Inc. > tel: 1-877-GKX-GROUP > email: ggrothendieck at gmail.com > -- *Victoria Concordia Crescit* [[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.