years

Applies NNN years modifier to a date/time value.

This function translates to the 'NNN years' modifier in SQLite's date and time functions. You can pass a negative integer to subtract years.

Example

// Add 5 years to the current date
select(DATE().now().years(5)).execute()

// Subtract 10 years from the current date
select(DATE().now().years(-10)).execute()

Return

A KQLiteColumn with the year modifier applied.

Author

MOHAMMAD AZIM ANSARI

Parameters

years

The number of years to add. A negative value subtracts years.

See also