Mysql Date Now
Date Now in Mysql is used to find out the current date and time.
Understand with Example
The Tutorial illustrate an example from 'Mysql Date Now'. In this example we help you to find out the current date and time in Mysql. The Syntax below returns you the current date and time:
now ( ) :The now ( ) return you the current date and time in the field name Datenow.
Query:-
mysql> select now()as Datenow; |
Output:-
+---------------------+ | Datenow | +---------------------+ | 2008-12-22 12:47:03 | +---------------------+ 1 row in set (0.00 sec) |