Displaying 1 result from an estimated 1 matches for "adverse_events_detail".
2010 Apr 08
0
Reading dates in R using SQL and otherwise (and someinteresting behavior by the data editor)
...y 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"
>
> head(mydata$ae_datestarted)
[1] "2008-10-23 CDT" "2008-10-21 CDT" "2008-10-24 CDT" "2008-10-25 CDT"...