Quest

Manipulating Date Time and Text Data

STATUS Past
TOTAL REWARDS
$1,000
REWARD AMOUNT
$2
STARTS (GMT +08:00)
ENDS (GMT +08:00)

Learning Outcomes

By the end of this quest, you will be able to:

  • Handle date and time data types
  • Perform arithmetic operations on date time data
  • Manipulate text data

Quest Details

Introduction

In our final tutorial, we will delve into the realm of manipulating datetime and text data within SQL. This knowledge proves crucial and practical in real-world scenarios where managing substantial amounts of such data is a necessity.

We'll explore the intricacies of datetime data types, learn how to extract and modify date-time information using functions, and master techniques for parsing and manipulating text data, enabling precise alterations and value extraction from such datasets.

Deliverables

This quest has 1 deliverable.

  1. A screenshot of your MySQL WorkBench after running a specific SQL query

This quest is part of a campaign so do check out other quests!


Help Center Need help?

Find articles to support you through your journey or chat with our support team.

Help Center