Entering Microseconds in SQL Statements in MySQL

Q

How To Enter Microseconds in SQL Statements in MySQL?

✍: FYIcenter.com

A

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;
   09:26:50.123000
   
SELECT TIME('1997/01/31 09^26^50.000123') FROM DUAL;
   09:26:50.000123

 

Introduction to Date and Time Handling in MySQL

⇒⇒MySQL Database Tutorials

2016-10-16, 200👍, 0💬