[ÇóÖú]Õý¹æ±í´ïʽ

Ëæchu·çliu

Êý¾Ý¿â £ºACC2000
bable1 ±í½á¹¹
×Ö¶ÎÃû Êý¾ÝÀàÐÍ
ID int
Date datetime
Date ×Ö¶Îϵĵ±È»ÊÇ Date 2006-08-19
µ«ÊÇÒòΪÖÖÖÖÔ­Òò£¬
´ËÊý¾Ý¿âµÄ¼Ç¼±»ÊÖ¹¤Ð޸ĹýÓÚÊÇ
ÓÐЩ¼Ç¼²»·ûºÏDatetimeÊý¾ÝÀàÐÍÁË£¡ ±ÈÈç 200-08-19
Òò´Ëµ¼ÖÂACC2000ÏòSQL2000 ¸´ÖÆÊý¾Ý³ö´í
ÎÊÈçºÎÔÚASPÖÐÓ¦ÓÃÕý¹æ±í´ïʽÕÒµ½ÕâЩ´íÎóµÄÊý¾Ý£¬²¢·µ»ØÆäËùÔÚµÄID×ֶεÄÖµ£¿
¹òÇóʵÏִ˹¦ÄܵÄASP´úÂ룡
¼±.....................
ÎÒÖ»ÐèÒªÕâÊÇ yyyy-mm-ddde µÄÕâÖ־ͿÉÒÔÁË
'***********************************************
'ÒÔÏÂΪÎÒÕÒµ½µÄdatetimeÕý¹æ±í´ïʽ²»ÖªµÀÄܲ»ÓÃ

ÕâÊÇyyyy-mm-dd hh:mm:ss µÄ
/^(\d{4})\-(\d{2})\-(\d{2}) (\d{2}):(\d{2}):(\d{2})$/ ;
ÕâÊÇ yyyy-mm-ddde µÄ
/^(\d{4})\-(\d{2})\-(\d{2})$/
function validateCNDate( strValue ) {
var objRegExp = /^\d{4}(\-|\/|\.)\d{1,2}\1\d{1,2}$/

if(!objRegExp.test(strValue))
return false;
else{
var arrayDate = strValue.split(RegExp.$1);
var intDay = parseInt(arrayDate[2],10);
var intYear = parseInt(arrayDate[0],10);
var intMonth = parseInt(arrayDate[1],10);
if(intMonth > 12 || intMonth < 1) {
return false;
}
var arrayLookup = { '1' : 31,'3' : 31, '4' : 30,'5' : 31,'6' : 30,'7' : 31,
'8' : 31,'9' : 30,'10' : 31,'11' : 30,'12' : 31}
if(arrayLookup[parseInt(arrayDate[1])] != null) {
if(intDay <= arrayLookup[parseInt(arrayDate[1])] && intDay != 0)
return true;
}
if (intMonth-2 ==0) {
var booLeapYear = (intYear % 4 == 0 && (intYear % 100 != 0 || intYear % 400 == 0));
if( ((booLeapYear && intDay <= 29) || (!booLeapYear && intDay <=28)) && intDay !=0)
return true;
}
}
return false;
}