Quest
Manipulating Date Time and Text Data
STATUS
Past
TOTAL REWARDS
$1,000
REWARD AMOUNT
$2
PLAYERS JOINED
858
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.
- 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!
Need help?
Find articles to support you through your journey or chat with our support team.
Help CenterTop