Hi I can query a table from a mysql database with RMariaDB. One of the table's column indicates "trade_time" and contains values such as "09:55:02.113000". When I query this table I can not get fractional seconds. I get a value such as "09:55:02". Also I get a variable class such as "hms" and "difftime" for this column. Not character or POSIX* format. I tried both "datetime" and "varchar(25)" as column type of "trade_time" in mysql. How can I solve this problem?
Best regards Baki Ünal ______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
