[R] RMariaDB returns a query without microseconds

Baki UNAL b@k|un@| @end|ng |rom y@hoo@com
Mon Jul 26 18:07:24 CEST 2021


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



More information about the R-help mailing list