Date and Time


func.age

Subtract arguments, producing a “symbolic” result that uses years and months, rather than just days

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 April 06, 2022 at 10:08 AM EST: Initial Documentation Commit (371ae8f)