Displaying 1 result from an estimated 1 matches for "subject_number".
2010 Apr 08
0
Reading dates in R using SQL and otherwise (and someinteresting behavior by the data editor)
...arted)", 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 subject_number,
+ ae,
+ ae_ctcgrade,
+ ae_relationship,
+ ae_serious,
+ cast(ae_datestarted as datetime) as ae_datestarted,
+ ae_dateended,
+ ae_ongoing
+ from adverse_events_detail")
>
> class(mydata$ae_datestarted)
[1] "POSIXt" "POSIXct"
> mode(mydata$ae_datestarted...