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;


Converting Dates to Character Strings in MySQL

Writing Date and Time Literals in MySQL

Introduction to Date and Time Handling in MySQL

⇑⇑ MySQL Database Tutorials

2017-12-26, 1348🔥, 0💬