addWeek

`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.