Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll
Well done!
You have completed Reporting with SQL!
You have completed Reporting with SQL!
Preview
The dates stored in a database often don't suit a human reader. In this video we'll update the dates to be more friendly!
Documentation Links for Formatting Dates
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
To understand how we can manipulate
the output of dates and times,
0:00
let's talk about the different date types
that you may come across in a database.
0:01
There are three types of date datatypes.
0:07
Remember, datatypes prescribe the way
data in a column should be stored.
0:10
The first two are date and time.
0:15
For dates, you'd stored dates like this,
[SOUND] then time looks like this.
0:18
Then this datetime where date and
time are combined in a single column.
0:23
Datetimes must be written like this, but
this can be hard for people to read.
0:28
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