Click here to navigate the course.
Drag the edges to resize the window.
In Projects, you can keep track of your progress as you go throught the tasks. Check each item as you complete it!
We'll begin with dates. Dates are often written in the following format
1. Date: YYYY-MM-DD
2. Datetime or Timestamp: YYYY-MM-DD hh:mm:ss
We can use SQL's date functions to transform data into a desired format. Since date functions can be database specific, verify the functions that exist on your relational database management system.
For example, this statement
SELECT DATETIME(manufacture_time)
FROM baked_goods;
Would return the date and time for the manufacture_time column.