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.

Ads

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)

Advertisements

Share on Google+Share on Google+

Mysql Date to Number

Posted on: April 3, 2006 If you enjoyed this post then why not add us on Google+? Add us to your Circles

Advertisements

Ads
 

Discuss: Mysql Date to Number  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments:0

Ads

 

Ads