Query Results

Run a query to see results.

Database Schema

Schema undefined.
Code Editor
Learn

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);
Report a Bug
If you see a bug or any other issue with this page, please report it here.