Displaying 2 results from an estimated 2 matches for "ae_datestarted".
2010 Apr 08
0
Reading dates in R using SQL and otherwise (and someinteresting behavior by the data editor)
...as stripping off the date class every time I submitted the command "fix(mydata)." So I kept getting the mistaken impression that what I was doing wasn't working.
One thing I've noticed is that the class for my date is of the type POSIX. When I issue the command "head(mydata$ae_datestarted)", I get "CDT" tacked onto my date. I'll spend some additional time investigating this, but if an answer about how to get a class of date using my SQL command seems obvious to someone please let me know.
Thanks,
Paul
> mydata <- sqlQuery(channel,
+ "select subje...
2010 Apr 08
2
Reading dates in R using SQL and otherwise (and some interesting behavior by the data editor)
...o create date values in R proper, I noticed some interesting behavior on the part of the data editor. At first, this led me to believe that my efforts had been unsuccessful. The output from my R console below illustrates this behavior.
> test <- mydata
> test$test_date <- as.Date(test$ae_datestarted, format='%m/%d/%Y')
> class(test$test_date)
[1] "Date"
> mode(test$test_date)
[1] "numeric"
>
> fix(test)
(At this point, I clicked on the test_date column)
Warning: class discarded from column ‘test_date’
>
> class(test$test_date)
[1] "charac...