Practice Session1:22 with Andrew Chalkley
Let'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
You need to sign up for Treehouse in order to download course files.Sign up