27,579
社区成员
发帖
与我相关
我的任务
分享
<?xml version="1.0" ?>
<ROWDATA>
<ROW>
<C0>1</C0>
<SQDH>1000053992</SQDH>
<ZYHM></ZYHM>
<MZHM>10003</MZHM>
<BRLX>1</BRLX>
<SBBH></SBBH>
<FYXZID>XJ01</FYXZID>
<FYXZMC>自费</FYXZMC>
<BRZYID>10003</BRZYID>
<BRXM>门诊03</BRXM>
<BRXB>男</BRXB>
<CSRQ>1991-01-01</CSRQ>
<SFZH></SFZH>
<LXDH></LXDH>
<BRCH></BRCH>
<LXDZ></LXDZ>
<MZ>汉族</MZ>
<GJ>中国</GJ>
<SQYY>内乡县人民医院</SQYY>
<SQKS>急诊科</SQKS>
<SQYS>超级用户</SQYS>
<ZXKS>00040</ZXKS>
<JCSBLX>2</JCSBLX>
<SQSJ>2016-08-03 15:20:32</SQSJ>
<ZXSJ></ZXSJ>
<JCXM>16排CT头部平扫</JCXM>
<JCBW>颅脑</JCBW>
<ZS>咳嗽发烧三日</ZS>
<BS>发烧</BS>
<FZJC></FZJC>
<LCZD>感冒</LCZD>
<JCFY>280.0000</JCFY>
<SFJF>1</SFJF>
<SFQR>0</SFQR>
</ROW>
DECLARE @dt DATE='2016-08-20'
SELECT CASE WHEN CAST(GETDATE() AS DATE)<DATEADD(MM,DATEDIFF(mm,@dt,GETDATE()),@dt)
THEN CASE WHEN (DATEDIFF(mm,@dt,GETDATE())-1)=0 THEN RTRIM(DATEDIFF(dd,@dt,GETDATE()))+N'天' ELSE RTRIM((DATEDIFF(mm,@dt,GETDATE())-1)/12)+N'岁'+CASE WHEN (DATEDIFF(mm,@dt,GETDATE())-1)/12>=3 THEN '' ELSE RTRIM((DATEDIFF(mm,@dt,GETDATE())-1)%12)+N'月' END END
ELSE CASE WHEN DATEDIFF(mm,@dt,GETDATE())=0 THEN RTRIM(DATEDIFF(dd,@dt,GETDATE()))+N'天' ELSE RTRIM(DATEDIFF(mm,@dt,GETDATE())/12)+N'岁'+CASE WHEN DATEDIFF(mm,@dt,GETDATE())/12>=3 THEN '' ELSE RTRIM(DATEDIFF(mm,@dt,GETDATE())%12)+N'月' END END END
DECLARE @dt DATE='1991-01-01'
SELECT CASE WHEN CAST(GETDATE() AS DATE)>DATEADD(MM,DATEDIFF(mm,@dt,GETDATE()),@dt) THEN RTRIM((DATEDIFF(mm,@dt,GETDATE())-1)/12)+N'岁'+RTRIM((DATEDIFF(mm,@dt,GETDATE())-1)%12)+N'月' ELSE RTRIM(DATEDIFF(mm,@dt,GETDATE())/12)+N'岁'+RTRIM(DATEDIFF(mm,@dt,GETDATE())%12)+N'月' END
/*
(无列名)
25岁7月*/