In PostgreSQL, the date_part() function retrieves subfields such as the year, month, hour, or minute, part from a date/time value.
It’s equivalent to the extract() function, although with a slightly different syntax.
what is
How Extract() Works in PostgreSQL
In PostgreSQL, the extract() function retrieves subfields such as the year, month, hour, or minute, part from a date/time value.
It’s equivalent to the date_part() function, although with a slightly different syntax.
How justify_interval() Works in PostgreSQL
In PostgreSQL, the justify_interval() function adjusts an interval using justify_days and justify_hours. It allows you to use additional sign adjustments to adjust the interval.
How justify_days() Works in PostgreSQL
In PostgreSQL, the justify_days() function allows you to adjust an interval value, so that 30-day time periods are represented as months.
For example, if you have an interval of say, 30 days, justify_days() will return it as 1 mon.
How justify_hours() Works in PostgreSQL
In PostgreSQL, the justify_hours() function allows you to adjust an interval value, so that 24-hour time periods are represented as days.
For example, if you have an interval of say, 24 hours justify_hours() will return it as 1 day.
How IsFinite() Works in PostgreSQL
In PostgreSQL, the isfinite() function tests for a finite date, timestamp or interval.
This can be useful, because Postgres supports infinite dates/timestamps. For example, you could have a timestamp of infinity or negative infinity, and this function allows you to test for that.
How pg_typeof() Works in PostgreSQL
In PostgreSQL, the pg_typeof() function allows you to get the data type of any value.
More specifically, it returns the OID of the data type of the value that is passed to it. It returns a regtype, which is an OID alias type. Therefore it’s the same as an OID for comparison purposes but displays as a type name.
How Div() Works in PostgreSQL
In PostgreSQL, the div() function returns the integer quotient of its first argument divided by its second argument.
How the Power() Function Works in PostgreSQL
In PostgreSQL, the power() function returns its first argument raised to the power of its second argument.
How the Scale() Function Works in PostgreSQL
In PostgreSQL, the scale() function returns the scale of its argument.
The scale is the number of decimal digits in the fractional part.