关于日期的计算的小问题，在线等.............

[mingday]

数据库中一字段日期时间型，我想给这个值加上一个时间，如30分钟，如何实现

[tigerwen01]

用函数：
DateAdd()
　FUNCTION: 返回一个被改变了的日期。
　SYNTAX: DateAdd(timeinterval,number,date)
　ARGUMENTS: timeinterval is the time interval to add; number is amount of
time intervals to add; and date is the starting date.
　EXAMPLE: <%
currentDate = #8/4/99#
newDate = DateAdd("m",3,currentDate)
response.write newDate
%>

<%
currentDate = #12:34:45 PM#
newDate = DateAdd("h",3,currentDate)
response.write newDate
%>
　RESULT: 11/4/99
3:34:45 PM

"m" = "month";
"d" = "day";

If currentDate is in time format then,
"h" = "hour";
"s" = "second";

[meizz]

DateAdd("n", 30, "2003-4-30 14:54:23")

[cqfeng]

sql server
DATEADD ( datepart , number, date )

示例
此示例打印出 pubs 数据库中标题的时间结构的列表。此时间结构表示当前发布日期加上 21 天。

USE pubs
GO
SELECT DATEADD(day, 21, pubdate) AS timeframe
FROM titles
GO

minute 缩写 mi