[R] MySQL and DATE data type

Does anyone know how to deal with DATES in MySQL database connections? dbWriteTable converts dates in a data frame to a character. Thanks! -- Dr. Brett Ginsburg Assistant Professor Department of Psychiatry The University of Texas Health Science Center at San Antonio San Antonio, TX 78229 > 210-5

[R] RMySQL and dates

I am trying to read and write database tables that have a date field in them. I am constructing a data.frame, then using dbWriteTable to create the table and dbReadTable to read it. >datatbl<-data.frame( dates, trialnum, fooddel, ethdel, trialtime, trialtype, deliveries, food, ethanol, fcumr