MySQL Conversion Functions Challenge

# Introduction

In this project, you will learn how to use MySQL's common conversion functions to extract relevant information from the `emp` table in the `personnel` database. You will learn how to access MySQL, import data, and write a script to perform various date and time conversions on the data.

## 👀 Preview

MariaDB [personnel]> SOURCE /home/labex/project/ConversionFunctions.sql;
+------------+------------+
| Entry Date | New Date   |
+------------+------------+
| 80-12      | 1980-12-31 |
| 81-02      | NULL       |
| 81-02      | NULL       |
| 81-04      | 1981-04-16 |
| 81-09      | NULL       |
| 81-05      | 1981-05-15 |
| 81-06      | 1981-06-23 |
| 87-06      | 1987-06-27 |
| 81-11      | 1981-11-31 |
| 81-09      | 1981-09-22 |
| 87-06      | 1987-06-27 |
| 81-12      | 1981-12-17 |
| 81-12      | 1981-12-17 |
| 82-01      | NULL       |
+------------+------------+
14 rows in set, 4 warnings (0.000 sec)

## 🎯 Tasks

In this project, you will learn:

- How to access MySQL using the `sudo` command without a password
- How to import data from a SQL file into the MySQL database
- How to write a SQL script to perform date and time conversions using functions like `DATE_FORMAT()` and `STR_TO_DATE()`
- How to display the results of the conversion functions with appropriate aliases

## 🏆 Achievements

After completing this project, you will be able to:

- Understand how to use MySQL's conversion functions to manipulate and display date and time data
- Write SQL scripts to perform complex data transformations
- Apply your knowledge of MySQL to solve real-world data processing problems