Get Current time : Time « Date Time « SQL / MySQL






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

Get Current time

  
/*
mysql> SELECT NOW();
+---------------------+
| NOW()               |
+---------------------+
| 2005-10-11 21:49:15 |
+---------------------+
1 row in set (0.00 sec)


*/  
SELECT NOW();








Related examples in the same category

1.Extract the entire time value by using the TIME() function: TIME(
2.Comparing Times to One Another
3.TIME type column
4.Compare time value
5.Alias column for constant time value
6.Calculates the sum of the two TIME values
7.Return the total working time, using SUM.