OK, daylight saving time, may be be cursed, is definitely my problem. Strangely, the DB has data for time 0000, 0100, 0200, 0400, 0500, ... 2300. It is closed source, so I have _no_ idea how this happened. And I cannot report bugs because it is no longer supported. The encoding is a 4 character (digit) field of the form HHMM. Why, I don't know.
But I have a work around which satisfies me and lets me get something for the boss. On Wed, Jul 30, 2014 at 1:07 PM, 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 -- 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.
