Collections:
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; 09:26:50.123000 SELECT TIME('1997/01/31 09^26^50.000123') FROM DUAL; 09:26:50.000123
⇒ Converting Dates to Character Strings in MySQL
⇐ Writing Date and Time Literals in MySQL
2017-12-26, 1301🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDAT...
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...