Add Microsecond to time : TIMESTAMP « Date Time « SQL / MySQL

1. SQL / MySQL
2. Date Time
3. TIMESTAMP

Add Microsecond to time

     
mysql>
mysql> CREATE TABLE TSTAMP (COL1 TIMESTAMP);
Query OK, 0 rows affected (0.00 sec)

mysql>
mysql> SET @TIME = TIMESTAMP('1980-12-08 23:59:59.59');
Query OK, 0 rows affected (0.00 sec)

mysql>
mysql> INSERT INTO TSTAMP VALUES (@TIME + INTERVAL 3 MICROSECOND);
Query OK, 1 row affected (0.00 sec)

mysql>
mysql> SELECT COL1, COL1 + INTERVAL 3 MICROSECOND FROM TSTAMP;
+---------------------+-------------------------------+
| COL1                | COL1 + INTERVAL 3 MICROSECOND |
+---------------------+-------------------------------+
| 1980-12-08 23:59:59 | 1980-12-08 23:59:59.000003    |
+---------------------+-------------------------------+
1 row in set (0.00 sec)

mysql>
mysql> drop table tstamp;
Query OK, 0 rows affected (0.00 sec)

   
    
    
    
    
  

Related examples in the same category