Preview
Video Player
00:00
00:00
Practice Session
1:22Let's practice all the date functions we've learned about.
Our time has almost come to an end.
0:00
You've learned a lot through this course.
0:03
You can filter, order and
paste the results.
0:05
You can also work with text,
numbers and now dates.
0:08
[SOUND] You've used the DATE
function to get today's date
0:11
with the time string of now.
0:15
[SOUND] The DATE function has been
used to trim off the time portion of
0:17
a time string.
0:21
The DATE function has been used with
a modifier to calculate dates too.
0:22
You can do the same with
the TIME function too.
0:26
Use the "now" string to
get the time of now.
0:30
The TIME function is used to removed
the date from the time string.
0:34
And finally, you can use modifiers
to create new date strings.
0:37
[SOUND] You've learned to format text
in any way you want using values that
0:40
can be substituted by parts of the date
passed in the second argument of this
0:45
STRFTIME function.
0:50
Finally, it's time for
you to practice what you've learned.
0:51
Open up the SQL Playground now by pressing
the launch SQL Playground button.
0:56
Review the schema down here, and then work
your way through these coding areas here
1:00
and answer the questions with
your newfound knowledge.
1:05
After your practice session,
1:09
you should be feeling more
comfortable reporting with SQL.
1:10
It's time for me to say goodbye,
but I'm sure I'll see you again.
1:14
I'll let you get on with
your practice session, and
1:17
then you can take your final assessment.
1:19