Tag : DATEDIFF()

ItSolutionStuff.com have tutorials for DATEDIFF() tag, here you can study articles of DATEDIFF() tag, DATEDIFF() tag posts collection, most popular and useful tutorials of DATEDIFF() tag, here you can find list of all relevant posts and example about DATEDIFF() tag, we have lists of tutorials and examples about DATEDIFF() tag. very simple and quick example collection of Latest DATEDIFF() 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 | | 13011 Viewer | Category : MySql
READ MORE

    Laravel 5.3 - import export csv and excel file into database

    Laravel 5.3 - import export csv and excel file into database

    Open Post

    Laravel 5 Facebook authentication using Socialite Package

    Laravel 5 Facebook authentication using Socialite Package

    Open Post

    Laravel 5.5 CRUD Example from scratch

    Laravel 5.5 CRUD Example from scratch

    Open Post

    PHP - Behance API tutorial with example and demo

    PHP - Behance API tutorial with example and demo

    Open Post

    Multi select autocomplete jquery example with code

    Multi select autocomplete jquery example with code

    Open Post

    Laravel 5 export to pdf using maatwebsite example

    Laravel 5 export to pdf using maatwebsite example

    Open Post