Learn PHP

Search This Blog

How to get AGE in mysql / sql

Posted by Unknown on August 11, 2015

Get link
Facebook
X
Pinterest
Email
Other Apps

SELECT TIMESTAMPDIFF(YEAR,'1986-09-14',CURDATE()) AS age

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

Basic of AnjularJs | AngularJs with Examples | One way-data

one way Data Binding in AngularJS <script src="https://ajax.googleapis.com/ajax/libs/angularjs/1.4.8/angular.min.js"></script> <div ng-app="" ng-init="fname='Manojkumar'; mname='Balaji'; "><strong>FirstName</strong> :{{fname}} <strong>MiddleName</strong> : <span ng-bind="mname"></span> </div> FirstName :{{fname}} MiddleName :

All Mysql JOIN with example.

Note: FULL JOIN doesn't support to Mysql so we can use UNION or UNION ALL select ed.empid, ed.emp_name, ed.emp_Join, edesg.designation from emp_data ed FULL JOIN emp_dseg edesg ON ed.empid = edesg.empid; mysql> select * from emp_data; +-------+------------+------------+ | empid | emp_name | emp_Join | +-------+------------+------------+ | 1 | Ajay | 2015-01-11 | | 2 | Anji | 2015-01-05 | | 3 | Sabhapathi | 2015-11-11 | | 4 | Bhasker | 2015-04-11 | | 5 | Raju | 2014-01-10 | | 6 | Mahipal | 2015-01-15 | | 7 | Manoj | 2015-09-14 | | 8 | Ragvendra | 2015-06-05 | | 9 | Sundheer | 2015-01-09 | | 10 | Mahi | 2015-01-1 | | 11 | Vijay | 2015-01-05 | | 12 | Sandip | 2015-01-1 | +-------+------------+------------+ 12 rows in set (0.00 sec) mysql> select * from emp_dseg; +-------+----------------------+ | empid | designation | +-------+----------------------+ | 1 | Dev

Powered by Blogger

All rights resever for http://learnphp4mmanoj.blogspot.com

How to get AGE in mysql / sql

Comments

Post a Comment