حضرت خواجہ سیدنا معین الدین حسن چشتی سنجاری اجمیری رحمۃ اللہ علیہ

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

nauna

0 3

thank you but it looks very long query, is there any short version of it

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