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, 1311🔥, 0💬
Popular Posts:
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...
Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...