meta data for this page
addWeek
Library: fbudf
Added in: 1.0 (Win), 1.5 (Linux)
Description
Returns the first argument with number weeks added. Use negative numbers to subtract.
Result type: TIMESTAMP
Syntax
addweek (atimestamp, number)
Declaration
DECLARE EXTERNAL FUNCTION addWeek TIMESTAMP, INT RETURNS TIMESTAMP ENTRY_POINT 'addWeek' MODULE_NAME 'fbudf'
The DATEADD alternative: The internal function DATEADD, which can replace all the other add<DateTimePart> functions, doesn't support WEEK yet. This will be realised in Firebird 2.5. Meanwhile, you can use DATEADD(7*number DAY TO atimestamp) – or stick with addWeek.