minus
Applies -YYYY-MM-DD modifier to a date/time value.
This function translates to the '-YYYY-MM-DD' modifier in SQLite's date and time functions. It's the counterpart to plusDate.
Example
select(
DATE("2001-03-02").minusDate(DateLiteral("2000-02-01")),
).execute()Content copied to clipboard
Return
A KQLiteColumn with the modifier applied.
Author
MOHAMMAD AZIM ANSARI
Parameters
date
The column containing the date/time modifier string (e.g., '+7 days') or a Julian day number to subtract.