Menu

Articles

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

How to use the MySQL UNIX_TIMESTAMP() function

In this article, we will learn how to use the MySQL UNIX_TIMESTAMP() function, which returns the number of seconds since the Unix epoch (1970-01-01 00:00:00 UTC) for a given date or datetime value.

How to Install SQLite on CentOS Stream 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 CentOS Stream 9 and want to install SQLite, this step-by-step tutorial will guide you through the process.

How to use the MySQL TO_SECONDS() function

In this article, we will learn how to use the MySQL TO_SECONDS() function, which returns the number of seconds from year 0 to a given date or datetime value.

How the BINARY operator works in Mariadb?

The BINARY operator in MariaDB is used to force a binary collation on the operand.

How to Install SQLite on CentOS Stream 8 (Legacy Guide)

Legacy guide to installing SQLite on CentOS Stream 8, which stopped receiving builds in May 2024. Use a supported release for new systems.

How to use the MySQL TO_DAYS() function

In this article, we will learn how to use the MySQL TO_DAYS() function, which returns the number of days from year 0 to a given date.

How the BIN() function works in Mariadb?

The BIN() function in MariaDB is a simple yet powerful function used to convert a decimal number into its binary equivalent.

How to Install SQLite on CentOS 8 (Legacy Guide)

Install SQLite on CentOS Linux 8 for an existing system. CentOS 8 support ended in 2021; use a maintained Linux release for new deployments.

How to use the MySQL TIMESTAMPDIFF() function

In this article, we will learn how to use the MySQL TIMESTAMPDIFF() function, which returns the difference between two timestamp values, in a specified unit.

How the BETWEEN AND operator works in Mariadb?

The BETWEEN AND operator in MariaDB is used to filter the result set within a certain range.