Mysql Date to Number

We already illustrate with an example of Current Date and Time in Mysql. Now this tutorial illustrate an example for  Mysql Date to Number. To grasp this example, we use the given Mysql Query that return you the Date to Number.

now ( ) +0 as number : The Query return you the current date to a number in number field name.

Query for converting current date and time to number:-

mysql> select now()+0 as number;

Output:-

+-----------------------+
| number                |
+-----------------------+
| 20081222170227.000000 |
+-----------------------+
1 row in set (0.00 sec)

Related Tags for Mysql Date to Number:

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 to Number  

Post your Comment

Your Name (*) :

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