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!

Query Results

Run a query to see results.

Database Schema

Schema undefined.
Code Editor
Date, Number, and String Functions

Dates II

Nice work! Now let's assume that we have a column in our baked_goods table named manufacture_time in the format YYYY-MM-DD hh:mm:ss.

We'd like to know the number of baked_goods manufactured by day, and not by second. We can use the DATE() function to easily convert timestamps to dates and complete the following query:

SELECT DATE(manufacture_time), count(*) as count_baked_goods FROM baked_goods GROUP BY DATE(manufacture_time);

Similarly, we can query the time with

SELECT TIME(manufacture_time), count(*) as count_baked_goods FROM baked_goods GROUP BY TIME(manufacture_time);
Community Forums
Get help and ask questions in the Codecademy Forums
Report a Bug
If you see a bug or any other issue with this page, please report it here.