Re: [R] RMariaDB returns a query without microseconds

Am Mon, 26 Jul 2021 16:07:24 + (UTC) schrieb Baki UNAL via R-help : > 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 >

Re: [R] RMariaDB returns a query without microseconds

Afternoon, > https://mariadb.com/kb/en/microseconds-in-mariadb/ -- seems you're > hitting a MariaDB (or perhaps, inherited from MySQL) limitation here. -- H > -- OpenPGP: https://hasan.d8u.us/openpgp.asc If you wish to request my time, please do so using *bit.ly/hd1AppointmentRequest

[R] RMariaDB returns a query without microseconds

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