Displaying 1 result from an estimated 1 matches for "ae_ctcgrade".
2010 Apr 08
0
Reading dates in R using SQL and otherwise (and someinteresting behavior by the data editor)
...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)
[1] "numeric&quo...