Mysql Date now function

Mysql Date now function is useful when you want to return the current time and date .

Understand with Example

The Tutorial illustrate an example from 'Mysql Date now function'. In this Tutorial we define a now ( ) Query that return you the current date and time.

now ( ) : The now ( ) function return you the current date and time as DatenowFunction.

Query:-

mysql> select now()as DatenowFunction;

Output:-

+---------------------+
| DatenowFunction     |
+---------------------+
| 2008-12-22 13:05:44 |
+---------------------+
1 row in set (0.20 sec)

Related Tags for Mysql Date now function:

More Tutorials from this section

• SQL Date, SQL Date Examples
• SQL Date
• MySQL By Date
• MySQL By Week
• Mysql date API
• Mysql Date Arithmetic
• Mysql Date in between
• Mysql Date Default
• Mysql date equal
• Mysql date field
• Mysql Date Filter
• Mysql Date Format codes
• Mysql Date Format Convert
• Mysql Date Format
• Mysql Date from Date
• Mysql Date and Time
• Mysql Date Functions
• Mysql Date Index
• Mysql Date Input
• Mysql Date To Java Date

Ask Questions?    Discuss: Mysql Date now function  

Post your Comment

Your Name (*) :

Your Email :
Subject (*):
Your Comment (*):