DECLARE
@s
datetime
,@e
datetime
![](https://i-blog.csdnimg.cn/blog_migrate/905da892328cca1b4402ed9573eb718d.gif)
SET
@s
=
'
1978-2-24
'
--
写你的生日
SET
@e
=
getDate
()
+
1
![](https://i-blog.csdnimg.cn/blog_migrate/905da892328cca1b4402ed9573eb718d.gif)
DECLARE
@y
int
,@m
int
,@d
int
![](https://i-blog.csdnimg.cn/blog_migrate/905da892328cca1b4402ed9573eb718d.gif)
SET
@y
=
DATEDIFF
(yy,@s,@e)
SET
@s
=
DATEADD
(yy,@y,@s)
![](https://i-blog.csdnimg.cn/blog_migrate/905da892328cca1b4402ed9573eb718d.gif)
SET
@m
=
DATEDIFF
(mm,@s,@e)
SET
@s
=
DATEADD
(mm,@m,@s)
IF
@m
<
0
BEGIN
SET
@y
=
@y
-
1
SET
@m
=
@m
+
12
END
![](https://i-blog.csdnimg.cn/blog_migrate/905da892328cca1b4402ed9573eb718d.gif)
SET
@d
=
DATEDIFF
(dd,@s,@e)
IF
@d
<
0
BEGIN
SET
@m
=
@m
-
1
SET
@d
=
@d
+
32
-
Day
(@e
+
32
-
Day
(@e))
END
![](https://i-blog.csdnimg.cn/blog_migrate/905da892328cca1b4402ed9573eb718d.gif)
SELECT
CAST
(@y
AS
varchar
(
3
))
+
'
年
'
+
CAST
(@m
AS
varchar
(
2
))
+
'
月
'
+
CAST
(@d
AS
varchar
(
2
))
+
'
天
'
![](https://i-blog.csdnimg.cn/blog_migrate/905da892328cca1b4402ed9573eb718d.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/905da892328cca1b4402ed9573eb718d.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/905da892328cca1b4402ed9573eb718d.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/905da892328cca1b4402ed9573eb718d.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/905da892328cca1b4402ed9573eb718d.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/905da892328cca1b4402ed9573eb718d.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/905da892328cca1b4402ed9573eb718d.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/905da892328cca1b4402ed9573eb718d.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/905da892328cca1b4402ed9573eb718d.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/905da892328cca1b4402ed9573eb718d.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/905da892328cca1b4402ed9573eb718d.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/905da892328cca1b4402ed9573eb718d.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/905da892328cca1b4402ed9573eb718d.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/905da892328cca1b4402ed9573eb718d.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/905da892328cca1b4402ed9573eb718d.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/905da892328cca1b4402ed9573eb718d.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/905da892328cca1b4402ed9573eb718d.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/905da892328cca1b4402ed9573eb718d.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/905da892328cca1b4402ed9573eb718d.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/905da892328cca1b4402ed9573eb718d.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/905da892328cca1b4402ed9573eb718d.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/905da892328cca1b4402ed9573eb718d.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/905da892328cca1b4402ed9573eb718d.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/905da892328cca1b4402ed9573eb718d.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/905da892328cca1b4402ed9573eb718d.gif)