Calculate Year, Month and Day between Current and specified Date in SQL Server

nauna

hello,

i have datetime field in sql, i want to fetch age calculation in sql query like

dob: 01/01/1983

sql query to return

Years- Months- Days (36 Year, 2 Months, 5 days)

please advice

dharmend...

0 4

Hinauna,

There is no short version of query.

If you want to make it short then Create function and call it where you need.

Refer the below link and modify it.

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Display time elapsed few seconds ago, minute ago, hours ago, days ago and year ago in SQL Server