I meant what R commands did you use to change the database's version of the time/date object to the R version? Bill Dunlap TIBCO Software wdunlap tibco.com
On Wed, Jul 30, 2014 at 11:07 AM, John McKown <john.archie.mck...@gmail.com> wrote: > On Wed, Jul 30, 2014 at 12:54 PM, William Dunlap <wdun...@tibco.com> wrote: >>> I should have mentioned that I tried other time stamps, generated the >>> same way as "q" above. >> >> How did you generate q and in what time zone were you? > > I got it from an MS-SQL data base which is maintained by some > closed-source vendor software. But I manipulate the data in the SELECT > before sending it to R via ODBC. I need to double check the raw data > in the data base. > >> Note that 2am >> on 9 March 2014 is when 'daylight savings time' started in the parts >> of the US where it is observed. Does 2am exist or do we jump from >> 1:59:59 to 3:00:00? > > Hum, that hadn't occurred to me. I need to see what is in the DB. > > But I think you have found my problem. If I force the timezone to be > GMT, then the problem disappears. So that is what I'll do with this > data. > >> >> >> Bill Dunlap >> TIBCO Software >> wdunlap tibco.com > > -- > There is nothing more pleasant than traveling and meeting new people! > Genghis Khan > > Maranatha! <>< > John McKown ______________________________________________ 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.
