Skip to content

Database.Guide

Convert a Date to Julian Day in PostgreSQL

January 28, 2021July 20, 2020 by Ian

In PostgreSQL, you can convert a given date to its Julian day representation by using the to_char() function.

To do this, pass the date as the first argument, and 'J' as the second.

Read more

Categories PostgreSQL Tags date format, dates, how to

How Atanh() Works in PostgreSQL

July 19, 2020 by Ian

In PostgreSQL, atanh() is a hyperbolic function that returns the inverse hyperbolic tangent of its argument.

The argument and return value are provided as a double precision value.

Read more

Categories PostgreSQL Tags functions, mathematical functions, what is

How Acosh() Works in PostgreSQL

July 18, 2020 by Ian

In PostgreSQL, acosh() is a hyperbolic function that returns the inverse hyperbolic cosine of its argument.

The argument and return value are provided as a double precision value.

Read more

Categories PostgreSQL Tags functions, mathematical functions, what is

How Asinh() Works in PostgreSQL

July 17, 2020 by Ian

In PostgreSQL, asinh() is a hyperbolic function that returns the inverse hyperbolic sine of its argument.

The argument and return value are provided as a double precision value.

Read more

Categories PostgreSQL Tags functions, mathematical functions, what is

How Cosh() Works in PostgreSQL

July 16, 2020 by Ian

In PostgreSQL, cosh() is a hyperbolic function that returns the hyperbolic cosine of its argument.

The argument and return value are provided as a double precision value.

Read more

Categories PostgreSQL Tags functions, mathematical functions, what is

How Tanh() Works in PostgreSQL

July 15, 2020 by Ian

In PostgreSQL, tanh() is a hyperbolic function that returns the hyperbolic tangent of its argument.

The argument and return value are provided as a double precision value.

Read more

Categories PostgreSQL Tags functions, mathematical functions, what is

How Sinh() Works in PostgreSQL

July 14, 2020 by Ian

In PostgreSQL, sinh() is a hyperbolic function that returns the hyperbolic sine of its argument.

The argument and return value are provided as a double precision value.

Read more

Categories PostgreSQL Tags functions, mathematical functions, what is

How Mod() Works in PostgreSQL

July 13, 2020 by Ian

In PostgreSQL, mod() is a mathematical function that returns the remainder from division of the first argument (the dividend) by the second argument (the divisor).

Read more

Categories PostgreSQL Tags functions, mathematical functions, what is

How Width_Bucket() Works in PostgreSQL

July 12, 2020 by Ian

In PostgreSQL, width_bucket() is a mathematical function that assigns values to buckets (individual segments) in an equiwidth histogram.

The return type is int.

Read more

Categories PostgreSQL Tags functions, mathematical functions, what is

How the timezone() Function Works in PostgreSQL

January 28, 2021July 11, 2020 by Ian

In PostgreSQL, you can use the timezone() function to convert a timestamp to another timezone.

Read more

Categories PostgreSQL Tags date functions, dates, functions, what is
Older posts
Newer posts
← Previous Page1 … Page320 Page321 Page322 … Page422 Next →

About | Privacy Policy

© 2026 Database.Guide • All rights reserved