以年月日格式在sql server中查找年龄 [英] Find Age in sql server in Year Month Day Format

问题描述

如何在sqlserver中查找年龄，结果年龄必须为年月日"格式

How can i find age in sqlserver the resulting age must be in Year Month Days format

推荐答案

请参阅以下内容:

http://stackoverflow.com/Questions/57599/how-to-calculate-age-in-t-sql-with-years-months-and-days [ http://dba.fyicenter.com/faq/sql_server/Getting_Year_Month_Day_from_DATETIME_Values.html [ ^ ]

Refer these:

http://stackoverflow.com/questions/57599/how-to-calculate-age-in-t-sql-with-years-months-and-days[^]


http://dba.fyicenter.com/faq/sql_server/Getting_Year_Month_Day_from_DATETIME_Values.html[^]

查看这些可以帮助您的链接
http://social.msdn.microsoft.com /Forums/zh-CN/transactsql/thread/399a7e87-bc78-47a5-8cc2-2d2436886fd7/ [ http://stackoverflow.com/Questions/57599/how-to-calculate-age-in-t-sql-with-years-months-and-days [ http://sanjevsharma.blogspot.com/2009/04/calculate-age- using-sql-server.html [ ^ ]

see these links which help you
http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/399a7e87-bc78-47a5-8cc2-2d2436886fd7/[^]

http://stackoverflow.com/questions/57599/how-to-calculate-age-in-t-sql-with-years-months-and-days[^]

http://sanjevsharma.blogspot.com/2009/04/calculate-age-using-sql-server.html[^]

又一个链接:
http://www.tek-tips.com/faqs.cfm?fid=5842 [ ^ ]

One more link:
http://www.tek-tips.com/faqs.cfm?fid=5842[^]

这篇关于以年月日格式在sql server中查找年龄的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！