if($get('igtxtJeezGroupBox1_JeezTextBox17').value!='')//身份证号不为空 { var idnum=$get('igtxtJeezGroupBox1_JeezTextBox17').value; var year=idnum.substring(6,10); var month=idnum.substring(10,12); var day=idnum.substring(12,14); $get('JeezGroupBox1_JeezCalendarCombo4_input').value=year+'年'+month+'月'+day+'日';//给生日控件赋值 }
create function F_Age(@ID nvarchar(18)) returns int as begin return( datediff(yy, case when len(@ID)=18 then substring(@ID,7,8) when len(@ID)=15 then substring(@ID,7,6) end ,getdate()) ) end string birthday = ""; if (identityCard.Length == 18) { birthday = identityCard.Substring(6, 4) + "-" + identityCard.Substring(10, 2) + "-" + identityCard.Substring(12, 2); } if (identityCard.Length == 15) { birthday = "19" + identityCard.Substring(6, 2) + "-" + identityCard.Substring(8, 2) + "-" + identityCard.Substring(10, 2); } int age=DateTime.Now.Year - DateTime.Parse(birthday).Year;http://topic.csdn.net/u/20091104/10/0aaa14f2-6167-4446-8d50-ce8ad72bea19.html
function CheckIdCard() { var idCard = txtIdCard.getValue(); if (/^\d{17}(\d|x)$/i.test(idCard) || /^\d{15}$/i.test(idCard)) { var Nativeplace = idCard.substring(0, 6); var IsRightDate = IsRightDate(idCard).value; if (idCard.length == 18) { var IsRightIdcard = IsRightIdCard(idCard).value; if (IsRightDate == "False" || IsRightIdcard == "False") { return false; } } } if (_idCard.Length == 18) { strYear = txtIdCard.Text.Substring(6, 4); strMonth = txtIdCard.Text.Substring(10, 2); strDay = txtIdCard.Text.Substring(12, 2); } else if (_idCard.Length == 15) { strYear = txtIdCard.Text.Substring(6, 2); strMonth = txtIdCard.Text.Substring(8, 2); strDay = txtIdCard.Text.Substring(10, 2); } DateTime birdatetime = DateTime.Parse(strYear + "-" + strMonth + "-" + strDay); 以上是主要思路以及代码
select 出生年月=convert(varchar,datepart(yy,right(left(IDCardNo,14),8)))+'年' +convert(varchar,datepart(mm,right(left(IDCardNo,14),8)))+'月' from tb_UserInfo
<input id=txtcard />
<input id=txtdate />
<script language=javascript>
var card = document.getElementById('txtcard').value;
if(card.length == 18)
{
document.getElementById('txtdate').value = card.substr(6,8);
}
</script>
<input id=txtdate />
<script language=javascript>
function changedate()
{
var card = document.getElementById('txtcard').value;
if(card.length == 18)
{
card = card.substr(6,8);
document.getElementById('txtdate').value = card.substr(0,4) + '-' + card.substr(4,2) + '-' + card.substr(6,2);
}
}
</script>
if($get('igtxtJeezGroupBox1_JeezTextBox17').value!='')//身份证号不为空
{
var idnum=$get('igtxtJeezGroupBox1_JeezTextBox17').value;
var year=idnum.substring(6,10);
var month=idnum.substring(10,12);
var day=idnum.substring(12,14);
$get('JeezGroupBox1_JeezCalendarCombo4_input').value=year+'年'+month+'月'+day+'日';//给生日控件赋值
}
returns int
as
begin
return(
datediff(yy,
case when len(@ID)=18 then substring(@ID,7,8)
when len(@ID)=15 then substring(@ID,7,6)
end
,getdate()) )
end string birthday = "";
if (identityCard.Length == 18)
{
birthday = identityCard.Substring(6, 4) + "-" + identityCard.Substring(10, 2) + "-" + identityCard.Substring(12, 2);
}
if (identityCard.Length == 15)
{
birthday = "19" + identityCard.Substring(6, 2) + "-" + identityCard.Substring(8, 2) + "-" + identityCard.Substring(10, 2);
}
int age=DateTime.Now.Year - DateTime.Parse(birthday).Year;http://topic.csdn.net/u/20091104/10/0aaa14f2-6167-4446-8d50-ce8ad72bea19.html
function CheckIdCard() {
var idCard = txtIdCard.getValue();
if (/^\d{17}(\d|x)$/i.test(idCard) || /^\d{15}$/i.test(idCard)) {
var Nativeplace = idCard.substring(0, 6);
var IsRightDate = IsRightDate(idCard).value;
if (idCard.length == 18) {
var IsRightIdcard = IsRightIdCard(idCard).value;
if (IsRightDate == "False" || IsRightIdcard == "False") {
return false;
}
}
} if (_idCard.Length == 18)
{
strYear = txtIdCard.Text.Substring(6, 4);
strMonth = txtIdCard.Text.Substring(10, 2);
strDay = txtIdCard.Text.Substring(12, 2);
}
else if (_idCard.Length == 15)
{
strYear = txtIdCard.Text.Substring(6, 2);
strMonth = txtIdCard.Text.Substring(8, 2);
strDay = txtIdCard.Text.Substring(10, 2);
}
DateTime birdatetime = DateTime.Parse(strYear + "-" + strMonth + "-" + strDay);
以上是主要思路以及代码
select
出生年月=convert(varchar,datepart(yy,right(left(IDCardNo,14),8)))+'年'
+convert(varchar,datepart(mm,right(left(IDCardNo,14),8)))+'月' from tb_UserInfo