IT新动态
作者： | 程序代码： | [ 复制代码到剪贴板 ] |
function startOfDayDate(date) {
return createDateTime(year(date), month(date), day(date), 0, 0, 0);
}
function endOfDayDate(date) {
return createDateTime(year(date), month(date), day(date), 23, 59, 59);
}
示例：
<cfset start_time = startOfDayDate(‘2005-10-1’)>
<cfset end_time = endOfDayDate(‘’)>
select * from your_table where date_field between #start_time# AND #end_time#
return createDateTime(year(date), month(date), day(date), 0, 0, 0);
}
function endOfDayDate(date) {
return createDateTime(year(date), month(date), day(date), 23, 59, 59);
}
示例：
<cfset start_time = startOfDayDate(‘2005-10-1’)>
<cfset end_time = endOfDayDate(‘’)>
select * from your_table where date_field between #start_time# AND #end_time#
| Tags (标签) | 引用通告地址 (0) |
| Tags: Asp | Sql | Access |
 http://www.gogogo8.com/ver2/Blog/trackback.asp?tbID=87 http://www.gogogo8.com/ver2/Blog/trackback.asp?tbID=87&CP=GBK |
