Hi! I have table Information.
ID Surname Name Birthday
1 Pulodov Rustam 22.12.987
2 Asrori Yatim 06.02.1978
3 Sharipov Sadriddin 08.12.1991
4 Sayfurov Karomatullo 07.05.1980
I want this answer:
ID Surname Name Birthday Age
1 Sharipov Sadriddin 08.12.1991 24
2 Pulodov Rustam 22.12.987 27
3 Sayfurov Karomatullo 07.05.1980 35
4 Asrori Yatim 06.02.1978 37
I use this query, but not work.
SELECT Surname,Name,Birthday FLOOR((CAST(GETDATE() AS INTEGER)-CAST(Birthday AS INTEGER))/365.25) AS AGE FROM Information ORDER BY AGE ASC
How I can solve this? Please!!!