Menu

Articles

How to use the MySQL LAST_DAY() function

MySQL LAST_DAY() is a function that returns the last day of the month for a given date or datetime value. It can be used to find the end date of a period, such as a month, quarter, or year.

How to Install PostgreSQL on Red Hat 8: A Step-by-Step Tutorial

Install PostgreSQL 15 on Red Hat Enterprise Linux 8 by selecting its AppStream module, then initialize and start the server.

How to use the MySQL JSON_CONTAINS_PATH() function

MySQL JSON_CONTAINS_PATH() is a function that tests whether a JSON document contains data at a given path or paths.

How to use the MySQL JSON_CONTAINS() function

MySQL JSON_CONTAINS() is a function that tests whether a given JSON document contains a specific value, or a value at a specified path.

How to Install PostgreSQL on Oracle Linux 9: A Step-by-Step Tutorial

Install PostgreSQL 18 on Oracle Linux 9.8 or later with its AppStream module, initialize the database cluster, and start the service.

How to use the MySQL HOUR() function

MySQL HOUR() is a function that returns the hour part of a date or time value. It can be used to extract the hour from a datetime, date, or time expression.

How to Install PostgreSQL on Oracle Linux 8: A Step-by-Step Tutorial

Install PostgreSQL 16 on Oracle Linux 8.10 with its AppStream module, initialize the database cluster, and start the service.

How to use the MySQL GET_FORMAT() function

MySQL GET_FORMAT() is a function that returns a date or time format string. It can be used to format a date or time value according to a specific locale or standard.

How to Install PostgreSQL on Oracle Linux 7 (Legacy Guide)

Legacy Oracle Linux 7 PostgreSQL guide. Its default repository package is PostgreSQL 9.2, unsupported upstream; use Oracle Linux 9 for new installs.

How to use the MySQL FROM_UNIXTIME() function

The FROM_UNIXTIME() function in MySQL converts a Unix timestamp to a DATETIME value. It is useful for working with timestamps from other systems or programming languages.