datetime_add()datetime_add()

• 10/29/2020
• • o
  • v

计算新的 datetime，方法是将指定 datapart 与指定数量相乘，然后加上指定 datetime。Calculates a new datetime from a specified datepart multiplied by a specified amount, added to a specified datetime.

语法Syntax

datetime_add(period,amount,datetime) datetime_add(period,amount,datetime)

参数Arguments

• period：字符串。period: string.
• amount：整数。amount: integer.
• datetime：datetime 值。datetime: datetime value.

period 的可能值：Possible values of period :

• YearYear
• QuarterQuarter
• MonthMonth
• WeekWeek
• 日期Day
• HourHour
• MinuteMinute
• SecondSecond
• MillisecondMillisecond
• MicrosecondMicrosecond
• NanosecondNanosecond

返回Returns

添加特定时间/日期间隔之后的日期。A date after a certain time/date interval has been added.

示例Examples

print  year = datetime_add('year',1,make_datetime(2017,1,1)),
quarter = datetime_add('quarter',1,make_datetime(2017,1,1)),
month = datetime_add('month',1,make_datetime(2017,1,1)),
week = datetime_add('week',1,make_datetime(2017,1,1)),
day = datetime_add('day',1,make_datetime(2017,1,1)),
hour = datetime_add('hour',1,make_datetime(2017,1,1)),
minute = datetime_add('minute',1,make_datetime(2017,1,1)),
second = datetime_add('second',1,make_datetime(2017,1,1))