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, 1389🔥, 0💬
Popular Posts:
How To Recover a Dropped Index in Oracle? If you have the recycle bin feature turned on, dropped ind...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
How To Convert Binary Strings into Integers in SQL Server Transact-SQL? Binary strings and integers ...
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...