PostgreSQL Date and Time Functions

The PostgreSQL age() function calculate the age according to the specified birthday and returns the age in the format of x years x mons x days.

The PostgreSQL clock_timestamp() function returns the date and time when this function was executed. Two executions of clock_timestamp() may return different values.

The PostgreSQL current_date function returns the current system date in the format YYYY-MM-DD.

The PostgreSQL current_time function returns the system time with time zone information in the format HH:MM:SS.ssssss{+|-}ZZ.

The PostgreSQL current_timestamp() function returns the current date and time (start of current transaction).

The PostgreSQL date_bin() function truncates the specified timestamp to the beginning of the nearest specified interval.

The PostgreSQL date_part() function extracts the specified field from the specified timestamp or interval and returns the result.

The PostgreSQL date_trunc() function truncates a specified timestamp or interval value to the specified part and returns the result.

The PostgreSQL extract() function extracts the specified field from the specified timestamp or time interval and returns it.

The PostgreSQL isfinite() function detects whether a given date, timestamp or interval value is finite.

The PostgreSQL justify_days() function converts the representation of time intervals, converting the number of days over 30 days to the number of months.

The PostgreSQL justify_hours() function converts the representation of time intervals, converting hours over 24 hours into days.

The PostgreSQL justify_interval() function converts the representation of time intervals, converting hours over 24 hours into days, and days over 30 days into months.

The PostgreSQL localtime function returns the current system time in the format HH:MM:SS.ssssss.

The PostgreSQL localtimestamp() function returns the system date and time when the transaction started.

The PostgreSQL make_date() function creates a date from the given year, month, and day fields.

The PostgreSQL make_interval() function creates an interval value from the given year, month, day, hour, minute, and second fields.

The PostgreSQL make_time() function creates a time from the given hour, minute, and second fields.

The PostgreSQL make_timestamp() function creates a timestamp value from the given year, month, day, hour, minute, and second fields.

The PostgreSQL make_timestamptz() function creates a timestamp value from the given year, month, day, hour, minute, second, timezone fields.

The PostgreSQL now() function returns the system date and time when the current transaction started.

The PostgreSQL pg_sleep() function suspends the execution of the current server process for the specified number of seconds.

The PostgreSQL pg_sleep_for() function receives an interval parameter that pauses the execution of the current server process for the specified interval.

The PostgreSQL pg_sleep_until() function receives a timestamp value and pauses the execution of the current server process until this specified moment.

The PostgreSQL statement_timestamp() function returns the timestamp for the starting execution of the current statement.

The PostgreSQL timeofday() function returns a string representing the timestamp of when this function was executed.

The PostgreSQL to_date() function converts the specified string to a date value according to the given format.

The PostgreSQL to_timestamp() function converts Unix epoch time to a standard timestamp with time zone information, or convert the specified string to timestamp according to the given format.

The PostgreSQL transaction_timestamp() function returns the system date and time when the current transaction started.