search for: subject_numb

Displaying 1 result from an estimated 1 matches for "subject_numb".

Did you mean: subject_name
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_datestart...