func.age
Subtract arguments, producing a “symbolic” result that uses years and months, rather than just days
Date and Time
func.clock_timestamp
Current date and time (changes during statement execution)
func.current_date
Returns current date value based on the start of the current transaction
func.current_time
Returns a current time value based on the time zone
func.current_timestamp
Returns a current date and timestamp based on the local time zone and start of current transaction
func.date_part
Returns a 'date' value expression through its subfields
func.date_trunc
Truncate input value to specified precision
func.extract
Retrieves subfields such as year or hour from date/time values
func.isfinite
This function is used to determine whether the numeric value is finite
func.justify_days
Adjust interval so 30-day time periods are represented as months
func.justify_hours
Adjust interval so 24-hour time periods are represented as days
func.justify_interval
This function is used to adjust interval using justify_days and justify_hours, with additional sign adjustments
func.now
Returns current date and time based on the database server's time zone setting
func.statement_timestamp
This function is used to get current date and time (start of current transaction)
func.timeofday
This function is used to get current date and time (like clock_timestamp, but as a text string)
func.transaction_timestamp
Returns the current date and time (including the time zone offset), at the start of the current transaction. Equivalent to 'func.now'
Last modified December 20, 2022 at 10:05 AM EST: remove sitemap priority (56709da)