SQLDateModifier
public enum SQLDateModifier : SQLSpecificExpressible
A date modifier for SQLite date functions such as julianDay(_:_:)
and
dateTime(_:_:)
.
For more information, see https://www.sqlite.org/lang_datefunc.html
-
Adds the specified amount of seconds
Declaration
Swift
case second(Double)
-
Adds the specified amount of minutes
Declaration
Swift
case minute(Int)
-
Adds the specified amount of hours
Declaration
Swift
case hour(Int)
-
Adds the specified amount of days
Declaration
Swift
case day(Int)
-
Adds the specified amount of months
Declaration
Swift
case month(Int)
-
Adds the specified amount of years
Declaration
Swift
case year(Int)
-
Shifts the date backwards to the beginning of the current day
Declaration
Swift
case startOfDay
-
Shifts the date backwards to the beginning of the current month
Declaration
Swift
case startOfMonth
-
Shifts the date backwards to the beginning of the current year
Declaration
Swift
case startOfYear
-
Declaration
Swift
case weekday(Int)
-
Declaration
Swift
case unixEpoch
-
Declaration
Swift
case localTime
-
Declaration
Swift
case utc
-
Declaration
Swift
public var sqlExpression: SQLExpression { get }