Hello Guys,.
I've suffering with a problem since last night, actually I've a date of birth(DOB) of any person and I want to find out the current age of that person but I don't have any idea about it. Can you tell how do this?
Please resolve my problem.
Technology
Web App Development
Mobile App Development
Windows App Development
Database Development
UI/UX Development
Cloud Development
SEO
Digital Marketing
Guest Posting
Content Writing
Artificial Intelligence
Data Science
ERP Development
CRM Development
CMS Development
LMS Development
Business Listing
Blockchain Technology
Startup Promotion
AI Tools Integration
Hi, Mr. Pravesh Singh
you can use simple query for solving your problem.
SELECT DATEDIFF(year,'1989-12-05',getdate()) 'Age'
Here DateDiff() is a Sql aggregate Function that will return difference between two dates, and getdate() method will return current system DateTime.