Tag : DATEDIFF()


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 | | 2071 Viewer | Category : MySql
READ MORE

    Codeigniter 3 - Generate PDF from view using dompdf library with example

    Codeigniter 3 - Generate PDF from view using dompdf library with example

    Open Post

    Jquery select2 ajax autocomplete example with demo in PHP

    Jquery select2 ajax autocomplete example with demo in PHP

    Open Post

    Ajax Image Upload using PHP and jQuery Example from scratch

    Ajax Image Upload using PHP and jQuery Example from scratch

    Open Post

    Multi select autocomplete jquery example with code

    Multi select autocomplete jquery example with code

    Open Post

    Jquery - Show hide password in Password textbox using checkbox.

    Jquery - Show hide password in Password textbox using checkbox.

    Open Post

    PHP Codeigniter - Ajax Infinite Scroll Pagination Example

    PHP Codeigniter - Ajax Infinite Scroll Pagination Example

    Open Post