Constants
A constant is a fixed value that you can use in an expression.
- date
Inserts the current system date. - date-time
Inserts the current system date and time. - time with time zone
Inserts a zero time with time zone. - timestamp with time zone
Inserts an example of a timestamp with time zone. - interval
Inserts a zero interval: 000 00:00:00.000. - interval year
Inserts a zero year interval: 0 year. - interval month
Inserts a zero month interval: 0 month. - interval year to month
Inserts a zero year to month interval: 0000-00 year to month. - interval day
Inserts a zero day interval: 0 day. - interval hour
Inserts a zero hour interval: 0 hour. - interval minute
Inserts a zero minute interval: 0 minute. - interval second
Inserts a zero second interval: 0 second. - interval day to hour
Inserts a zero day to hour interval: 0 00 day to hour. - interval day to minute
Inserts a zero day to minute interval: 0 00:00 day to minute. - interval day to second
Inserts a zero day to second interval: 0 00:00:00.000000000 day to second. - interval hour to minute
Inserts a zero hour to minute interval: 00:00 hour to minute. - interval hour to second
Inserts a zero hour to second interval: 00:00:00.000000000 hour to second. - interval minute to second
Inserts a zero minute to second interval: 00:00.000000000 minute to second. - null
Inserts "null" if the expression conditions are not met. - number
Inserts the number 0, which can be replaced with a new numeric value. - string
Inserts an empty string as two single quotation marks between which you can type a string. - time
Inserts the current system time.
Parent topic: Using the expression editor