Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Sql Sqldate Mysql Date to Number

Related Tutorials


 
 

Share on Google+Share on Google+

Mysql Date to Number

Advertisement
We already illustrate with an example of Current Date and Time in Mysql. Now this tutorial illustrate an example for Mysql Date to Number.

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)
Advertisement

If you enjoyed this post then why not add us on Google+? Add us to your Circles



Liked it!  Share this Tutorial


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: April 3, 2006

Related Tutorials

Discuss: Mysql Date to Number  

Post your Comment


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