Entering Microseconds in SQL Statements in MySQL


How To Enter Microseconds in SQL Statements in MySQL?

✍: FYIcenter.com


If you want to enter microseconds in a SQL statements, you can enter them right after the time string as a 6-digit number delimited with '.'. '0' will be padded to right if not enough digits. Here are some good examples:

SELECT TIME('1997/01/31 09^26^50.123') FROM DUAL;
SELECT TIME('1997/01/31 09^26^50.000123') FROM DUAL;


Introduction to Date and Time Handling in MySQL

⇒⇒MySQL Database Tutorials

2016-10-16, 179👍, 0💬