Calculate the difference in time between NOWand UTC_TIMESTAMP : UTC_TIMESTAMP « Date Time « SQL / MySQL

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

Calculate the difference in time between NOWand UTC_TIMESTAMP

     
mysql>
mysql>
mysql> SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);
+--------------------------------+
| TIMEDIFF(NOW(), UTC_TIMESTAMP) |
+--------------------------------+
| -08:00:00                      |
+--------------------------------+
1 row in set (0.00 sec)

mysql>

   
    
    
    
    
  

Related examples in the same category