TimeStampAdd
Returns a timestamp calculated by adding N
DateTimeParts
(for
example, three hours) to the specified timestamp.
Syntax
TimeStampAdd(Timestamp, DateTimePart, N)
Parameters
Timestamp
The timestamp to add the specified number of DateTimeParts
to.
DateTimePart
The time interval to change the Timestamp
by. This parameter supports
the following values:
d
: dayh
: hour
N
The number of DateTimeParts
to add to the Timestamp
.
Example
The following expression adds two days to 2008-04-09:
[DateCustom].[Retail445].[Reporting Day].&[TimestampAdd(FloorTime("2008-04-09T11:35:04.201103"), "d", 2)]