How To Enter Microseconds In SQL Statements

How To Enter Microseconds In SQL Statements


  • 9 Mar, 2012

    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

    Comments Received:
    Please give your suggestions and feedback:

2009-2016 downloadmela.com. All rights reserved.