Get the current full date object, current date nd time : NOW « Date Time « SQL / MySQL

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

Get the current full date object, current date nd time

     
mysql>
mysql> SELECT NOW(), CURDATE(), CURTIME();
+---------------------+------------+-----------+
| NOW()               | CURDATE()  | CURTIME() |
+---------------------+------------+-----------+
| 2011-10-04 11:09:17 | 2011-10-04 | 11:09:17  |
+---------------------+------------+-----------+
1 row in set (0.00 sec)

   
    
    
    
    
  

Related examples in the same category