Home >> FAQs/Tutorials >> MySQL Tutorials
MySQL Tutorial - Entering Microseconds in SQL Statements
(Continued from previous topic...)
How To Enter Microseconds in SQL Statements?
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;
(Continued on next topic...)
- What Are Date and Time Data Types?
- How To Write Date and Time Literals?
- How To Enter Microseconds in SQL Statements?
- How To Convert Dates to Character Strings?
- How To Convert Character Strings to Dates?
- What Are Date and Time Intervals?
- How To Increment Dates by 1?
- How To Decrement Dates by 1?
- How To Calculate the Difference between Two Dates?
- How To Calculate the Difference between Two Time Values?
- How To Present a Past Time in Hours, Minutes and Seconds?
- How To Extract a Unit Value from a Date and Time?
- What Are Date and Time Functions?
- What Is TIMESTAMP Data Type?
- How Many Ways to Get the Current Time?