Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll
Preview
Start a free Courses trial
to watch this video
Let's practice all the date functions we've learned about.
Cheat Sheets
Related Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign upRelated Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign up
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
You need to sign up for Treehouse in order to download course files.
Sign upYou need to sign up for Treehouse in order to set up Workspace
Sign up