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*numberDAYTOatimestamp) – or stick with addWeek.