func.age
Subtract arguments, producing a “symbolic” result that uses years and months, rather than just days
Subtract arguments, producing a “symbolic” result that uses years and months, rather than just days
Current date and time (changes during statement execution)
Returns current date value based on the start of the current transaction
Returns a current time value based on the time zone
Returns a current date and timestamp based on the local time zone and start of current transaction
Returns a 'date' value expression through its subfields
Truncate input value to specified precision
Retrieves subfields such as year or hour from date/time values
This function is used to determine whether the numeric value is finite
Adjust interval so 30-day time periods are represented as months
Adjust interval so 24-hour time periods are represented as days
This function is used to adjust interval using justify_days and justify_hours, with additional sign adjustments
Returns current date and time based on the database server's time zone setting
This function is used to get current date and time (start of current transaction)
This function is used to get current date and time (like clock_timestamp, but as a text string)
Returns the current date and time (including the time zone offset), at the start of the current transaction. Equivalent to 'func.now'