Posts

How to use the MySQL MONTHNAME() function

In this article, we will learn how to use the MySQL MONTHNAME() function, which returns the name of the month for a given date.

How to Install Redis on CentOS 8: A Step-by-Step Tutorial

Redis is a blazing-fast, open-source, in-memory key-value store that is commonly used for caching, session management, and as a message broker. If you’re running CentOS 8 and wish to take advantage of Redis for your applications, this step-by-step tutorial will guide you through the installation process.

How to use the MySQL MONTH() function

In this article, we will learn how to use the MySQL MONTH() function, which returns the month of a given date as an integer value from 1 to 12.

How to Install Redis on CentOS 7: A Step-by-Step Tutorial

Redis is an open-source, in-memory data store that can be used as a caching mechanism and a NoSQL database. It is known for its speed and flexibility, making it a popular choice for a variety of applications. If you’re running CentOS 7 and want to harness the power of Redis, this step-by-step tutorial will guide you through the installation process.

How to use the MySQL MINUTE() function

MySQL MINUTE() is a function that returns the minute part of a date or time value.

How to Install PostgreSQL on Ubuntu 22.04: A Step-by-Step Tutorial

In this step-by-step tutorial, we will guide you through the process of installing PostgreSQL on an Ubuntu 22.04 LTS system.

How to use the MySQL MICROSECOND() function

MySQL MICROSECOND() is a function that returns the microsecond part of a date or time value.

How to Install PostgreSQL on Ubuntu 20.04: A Step-by-Step Tutorial

In this step-by-step tutorial, we will guide you through the process of installing PostgreSQL on an Ubuntu 20.04 LTS system.

How to use the MySQL MAKETIME() function

MySQL MAKETIME() is a function that creates and returns a time value based on an hour, minute, and second value.

How to Install PostgreSQL on Ubuntu 18: A Step-by-Step Tutorial

In this step-by-step tutorial, we will guide you through the process of installing PostgreSQL on an Ubuntu 18.04 LTS system.

How to use the MySQL MAKEDATE() function

MySQL MAKEDATE() is a function that returns a date by taking a value of a year and a number of days.

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

In this step-by-step tutorial, we will guide you through the process of installing PostgreSQL on a Rocky Linux 9 system.

How to use the MySQL LOCALTIMESTAMP() function

MySQL LOCALTIMESTAMP() is a function that returns the current date and time. It is a synonym for the NOW() function.

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

In this step-by-step tutorial, we will guide you through the process of installing PostgreSQL on a Rocky Linux 8 system.

How to use the MySQL LOCALTIME() function

MySQL LOCALTIME() is a function that returns the current date and time. It is a synonym for the NOW() function.

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

In this comprehensive step-by-step tutorial, we will guide you through the process of installing PostgreSQL on a Red Hat 9 system.

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

In this step-by-step tutorial, we will guide you through the process of installing PostgreSQL on a Red Hat 8 system.

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

In this step-by-step tutorial, we will guide you through the process of installing PostgreSQL on an Oracle Linux 9 system.

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

In this step-by-step tutorial, we will guide you through the process of installing PostgreSQL on an Oracle Linux 8 system.

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: A Step-by-Step Tutorial

In this comprehensive step-by-step tutorial, we will guide you through the process of installing PostgreSQL on an Oracle Linux 7 system.

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.

How to Install PostgreSQL on openSUSE: A Step-by-Step Tutorial

In this step-by-step tutorial, we will guide you through the process of installing PostgreSQL on an openSUSE system.

How to use the MySQL FROM_DAYS() function

The FROM_DAYS() function in MySQL converts a day number to a DATE value. It is useful for calculating dates based on an integer day number.

How to Install PostgreSQL on macOS with HomeBrew: A Step-by-Step Tutorial

This step-by-step tutorial will guide you through the process of installing PostgreSQL on macOS using Homebrew.

How to use the MySQL FORMAT() function

The FORMAT() function in MySQL allows you to format a number to a specific format. It is useful for formatting numbers for display purposes.

How to Install PostgreSQL on FreeBSD: A Step-by-Step Tutorial

In this step-by-step tutorial, we will guide you through the process of installing PostgreSQL on a FreeBSD system.

How to use the MySQL EXTRACT() function

The EXTRACT() function in MySQL retrieves a specific component from a date or datetime value. This can extract elements like day, month, year, etc.

How to Install PostgreSQL on Fedora: A Step-by-Step Tutorial

In this step-by-step tutorial, we will guide you through the process of installing PostgreSQL on a Fedora system.

How to use the MySQL `DAYOFYEAR()` function

The DAYOFYEAR() function in MySQL returns the day of the year for a given date. This can calculate the numeric day from 1 to 365 (or 366 in leap years).

How to Install PostgreSQL on Debian 12: A Step-by-Step Tutorial

In this comprehensive step-by-step tutorial, we will guide you through the process of installing PostgreSQL on a Debian 12 system.

How to use the MySQL DAYOFWEEK() function

The DAYOFWEEK() is a MySQL function that returns the weekday index for a given date. The days are indexed starting with 1 for Sunday through 7 for Saturday.

How to use the MySQL DAYOFMONTH() function

The DAYOFMONTH() is a MySQL function that returns the day of the month for a given date. This can be useful for extracting the numeric day from a DATE or DATETIME value in a query.

How to Install PostgreSQL on Debian 10: A Step-by-Step Tutorial

In this comprehensive step-by-step tutorial, we will guide you through the process of installing PostgreSQL on a Debian 10 system.

How to use the MySQL DAYNAME() function

The DAYNAME() function in MySQL returns the name of the weekday for a given date. It can be useful for formatting dates and timestamps.

How to Install PostgreSQL on CentOS Stream 9: A Step-by-Step Tutorial

In this step-by-step tutorial, we will guide you through the process of installing PostgreSQL on a CentOS Stream 9 system.

How to use the MySQL DAY() function

The DAY() function in MySQL is used to get the day of the month from a date value. It returns the day number (1-31) for the given date.

How to Install PostgreSQL on CentOS Stream 8: A Step-by-Step Tutorial

In this step-by-step tutorial, we will guide you through the process of installing PostgreSQL on a CentOS Stream 8 system.

How to use the MySQL DATEDIFF() function

The DATEDIFF() function in MySQL is used to calculate the difference between two dates in terms of a specified unit like days, weeks, months etc.

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

In this step-by-step tutorial, we will guide you through the process of installing PostgreSQL on a CentOS 8 server.

How to use the MySQL DATE_SUB() function

The DATE_SUB() function in MySQL is used to subtract a time/date interval from a date and return the new date. It is an alias for the SUBDATE() function.

How to Install PostgreSQL on CentOS 7: A Step-by-Step Tutorial

In this comprehensive tutorial, we will guide you through the process of installing PostgreSQL on a CentOS 7 server.

How to use the MySQL DATE_FORMAT() function

The DATE_FORMAT() function in MySQL is used to format a date value based on a specified date/time format string. This allows formatting dates in different ways.

How to Install MariaDB on Ubuntu 22: A Step-by-Step Tutorial

Ubuntu 22.04 (Jammy Jellyfish) is the latest LTS (Long Term Support) version of the Ubuntu Linux distribution. If you need to set up MariaDB, an open-source relational database management system, on your Ubuntu 22.04 system, this step-by-step tutorial will guide you through the installation process.

MySQL DATE() 用法与实例

The DATE() function in MySQL is used to extract the date part from a datetime expression. It returns the date in ‘YYYY-MM-DD’ format.

How to Install MariaDB on Ubuntu 20: A Step-by-Step Tutorial

Ubuntu 20.04 LTS (Focal Fossa) is a long-term support version of the Ubuntu Linux distribution. If you need to set up MariaDB, an open-source relational database management system, on your Ubuntu 20.04 system, this step-by-step tutorial will guide you through the installation process.