查询操作:
<td width="240">
<c:Calendar id="search_date" label="开始日期"
width="120" labelWidth="120" labelAlign="center"/>
</td>
实例化对象:
var dateVal = new Date(search_date.getValue());
格式转换:
var yy = dateVal.getYear();
if(yy<1900) yy = yy+1900;
var MM = dateVal.getMonth()+1;
if(MM<10) MM = '0' + MM;
var dd = dateVal.getDate();
if(dd<10) dd = '0' + dd;
var date = yy + MM + dd;
Oracle数据库查询条件:
if (!Ext.isEmpty(dateVal)) { //由于dateVal已经是对象无法进行为空判断,需要改为search_date.getValue()
condition += " and startDate >=to_date('"+date+"','YYYYMMDD')";
}
下面是参考:
仅针对这个问题来说,不需要那么大量的代码即可完成
方案1(适用于中国标准时间):
var
date =
new
Date(+
new
Date()+8*3600*1000).toISOString().replace(/T/g,
' '
).replace(/\.[\d]{3}Z/,
''
)
|
方案2(只用于题目中所述的格式转换):
var
date =
new
Date().toLocaleString().replace(/[年月]/g,
'-'
).replace(/[日上下午]/g,
''
);
|
方案3(最准确但最麻烦,不推荐):
var
date =
new
Date();
var
result = date.getFullYear()+
'-'
+(date.getMonth()+1)+
'-'
+date.getDate()+
' '
+date.getHours()+
':'
+date.getMinutes()+
':'
+date.getSeconds();
另一个回答
//Time
function
showLocale(objD)
{
var
str,colorhead,colorfoot;
var
yy = objD.getYear();
if
(yy<1900) yy = yy+1900;
var
MM = objD.getMonth()+1;
if
(MM<10) MM =
'0'
+ MM;
var
dd = objD.getDate();
if
(dd<10) dd =
'0'
+ dd;
var
hh = objD.getHours();
if
(hh<10) hh =
'0'
+ hh;
var
mm = objD.getMinutes();
if
(mm<10) mm =
'0'
+ mm;
var
ss = objD.getSeconds();
if
(ss<10) ss =
'0'
+ ss;
if
(hh <= 11)
var
amOrPm =
" am"
;
if
(hh > 11)
var
amOrPm =
" pm"
;
if
(hh > 12) hh = hh - 12;
if
(hh == 0) hh = 12;
var
ww = objD.getDay();
if
(ww==0) ww=
"星期日"
;
if
(ww==1) ww=
"星期一"
;
if
(ww==2) ww=
"星期二"
;
if
(ww==3) ww=
"星期三"
;
if
(ww==4) ww=
"星期四"
;
if
(ww==5) ww=
"星期五"
;
if
(ww==6) ww=
"星期六"
;
str = yy +
"-"
+ MM +
"-"
+ dd +
"- "
+ ww +
" "
+ hh +
":"
+ mm +
":"
+ ss + amOrPm;
return
(str);
}
function
tick()
{
var
today;
today =
new
Date();
document.getElementById(
"time"
).innerHTML = showLocale(today);
window.setTimeout(
"tick()"
, 1000);
}
tick();