1
00:00:00,770 --> 00:00:03,420
Our time has almost come to an end.

2
00:00:03,420 --> 00:00:05,160
You've learned a lot through this course.

3
00:00:05,160 --> 00:00:08,050
You can filter, order and
paste the results.

4
00:00:08,050 --> 00:00:11,240
You can also work with text,
numbers and now dates.

5
00:00:11,240 --> 00:00:15,570
[SOUND] You've used the DATE
function to get today's date

6
00:00:15,570 --> 00:00:17,190
with the time string of now.

7
00:00:17,190 --> 00:00:21,236
[SOUND] The DATE function has been
used to trim off the time portion of

8
00:00:21,236 --> 00:00:22,183
a time string.

9
00:00:22,183 --> 00:00:26,620
The DATE function has been used with
a modifier to calculate dates too.

10
00:00:26,620 --> 00:00:30,990
You can do the same with
the TIME function too.

11
00:00:30,990 --> 00:00:34,030
Use the "now" string to
get the time of now.

12
00:00:34,030 --> 00:00:37,580
The TIME function is used to removed
the date from the time string.

13
00:00:37,580 --> 00:00:40,725
And finally, you can use modifiers
to create new date strings.

14
00:00:40,725 --> 00:00:45,501
[SOUND] You've learned to format text
in any way you want using values that

15
00:00:45,501 --> 00:00:50,433
can be substituted by parts of the date
passed in the second argument of this

16
00:00:50,433 --> 00:00:51,859
STRFTIME function.

17
00:00:51,859 --> 00:00:56,070
Finally, it's time for
you to practice what you've learned.

18
00:00:56,070 --> 00:01:00,250
Open up the SQL Playground now by pressing
the launch SQL Playground button.

19
00:01:00,250 --> 00:01:05,180
Review the schema down here, and then work
your way through these coding areas here

20
00:01:05,180 --> 00:01:07,647
and answer the questions with
your newfound knowledge.

21
00:01:09,380 --> 00:01:10,790
After your practice session,

22
00:01:10,790 --> 00:01:14,010
you should be feeling more
comfortable reporting with SQL.

23
00:01:14,010 --> 00:01:16,570
It's time for me to say goodbye,
but I'm sure I'll see you again.

24
00:01:17,630 --> 00:01:19,830
I'll let you get on with
your practice session, and

25
00:01:19,830 --> 00:01:21,820
then you can take your final assessment.