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) |
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.
Ask Questions? Discuss: Mysql Date to Number
Post your Comment