Skip to content
Prev 388623 / 398530 Next

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

Thread (2 messages)

Baki UNAL RMariaDB returns a query without microseconds Jul 26 Ralf Goertz RMariaDB returns a query without microseconds Jul 27