Posts

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.

How to use the MySQL DATE_ADD() function

The DATE_ADD() function in MySQL is used to add a time/date interval to a date and return a new date. It is an alias for the ADDDATE() function.

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

Ubuntu 18.04 LTS (Bionic Beaver) 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 18.04 system, this step-by-step tutorial will guide you through the installation process.

How to use the MySQL CURTIME() function

The CURTIME() function in MySQL returns the current time in ‘HH:MM:SS’ format. It is useful for inserting and comparing against the current time.

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

Rocky Linux 9 is a robust and community-driven Linux distribution known for its stability. If you need to set up MariaDB, an open-source relational database management system, on your Rocky Linux 9 system, this step-by-step tutorial will guide you through the installation process.

How to use the MySQL CURRENT_TIMESTAMP() function

The CURRENT_TIMESTAMP() function in MySQL returns the current date and time as a timestamp value. It is useful for inserting records with the current timestamp.

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

Rocky Linux 8 is a robust and community-driven Linux distribution known for its stability. If you need to set up MariaDB, an open-source relational database management system, on your Rocky Linux 8 system, this step-by-step tutorial will guide you through the installation process.

How to use the MySQL CURRENT_TIME() function

The CURRENT_TIME() function in MySQL returns the current time in ‘HH:MM:SS’ format. It can be used to insert or query time values based on the current time.

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

Red Hat Linux 9 is an enterprise-grade Linux distribution known for its stability and reliability. If you need to set up MariaDB, an open-source relational database management system, on your Red Hat Linux 9 system, this step-by-step tutorial will guide you through the installation process.

How to use the MySQL CURRENT_DATE() function

The CURRENT_DATE() function in MySQL returns the current date in ‘YYYY-MM-DD’ format. It is an alias for the CURDATE() function.

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

Red Hat Linux 8 is a powerful and widely used enterprise-grade Linux distribution. If you need to set up MariaDB, an open-source relational database management system, on your Red Hat Linux 8 system, this step-by-step tutorial will guide you through the installation process.