[R] RMariaDB returns a query without microseconds

[Baki UNAL]

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