Tag : Calculate

ItSolutionStuff.com have tutorials for Calculate tag, here you can study articles of Calculate tag, Calculate tag posts collection, most popular and useful tutorials of Calculate tag, here you can find list of all relevant posts and example about Calculate tag, we have lists of tutorials and examples about Calculate tag. very simple and quick example collection of Latest Calculate tag.

How to calculate age from date of birth column in mysql?

Sometimes, we require to get age from birthdate using mysql select query, we can do it in programming like php,.net and etc framework but if we can do it using mysql query. In bellow example mysql query you can learn how to get age from date field. We can get age value from using mysql DATEDIFF(). So, let's see bellow query. <strong>Example:</strong> <pre> SELECT id, (DATEDIFF(CURRENT_DATE, STR_TO_DATE(born_date, '%Y-%m-%d'))/365) as age FROM `users` </pre>

By Hardik Savani | June 1, 2016 | | 25275 Viewer | Category : MySql