Articles

For side-by-side syntax and behavior across database engines, browse the cross-database SQL comparison guides.

How the CENTROID() function works in Mariadb?

The CENTROID() function is a spatial function that returns the geometric center of a geometry value. The centroid of a geometry is the point that balances the geometry if it is placed on a plane.

How the DAYOFYEAR() function works in Mariadb?

The DAYOFYEAR() function is a date and time function that returns the day of the year for a given date.

Install SQLite on Red Hat Enterprise Linux 8

Install the SQLite command-line shell on RHEL 8 with DNF, verify sqlite3, and run a quick in-memory SQL check.

How the CEILING() function works in Mariadb?

The CEILING() function is a mathematical function that returns the smallest integer value that is greater than or equal to a given numeric value.

How the DAYOFWEEK() function works in Mariadb?

The MariaDB DAYOFWEEK() function is used to determine the day of the week for a given date, returning an integer value from 1 (Sunday) to 7 (Saturday).

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

SQLite is a lightweight, high-performance, self-contained relational database management system that is widely used for various applications. If you’re running Oracle Linux 9 and want to install SQLite, this step-by-step tutorial will guide you through the process.

How the CEIL() function works in Mariadb?

The CEIL() function is a mathematical function that returns the smallest integer value that is greater than or equal to a given numeric value.

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

SQLite is a lightweight, high-performance, self-contained relational database management system that is widely used for various applications. If you’re running Oracle Linux 8 and want to install SQLite, this step-by-step tutorial will guide you through the process.

How to use the MySQL YEARWEEK() function

In this article, we will learn how to use the YEARWEEK() function in MySQL. The YEARWEEK() function returns the year and week number for a given date, based on a specified mode.

How the CAST() function works in Mariadb?

The CAST() function is a conversion function that allows you to convert a value from one data type to another.