Yes, it can be used to show a timetable. You only need to transform your day value to a certain date.
The easiest way would be to pick a year which starts on the same day of the week. That's the case of 2012 (for weeks starting on Sunday). So you can store Sunday as 2012-01-01, Monday as 2012-01-02 etc.
You can also store days of week as integers and transform them to dates using your SELECT command.
In the Calendar, set HeaderDateFormat="dddd" to show just the name of the day in the header. Use BeforeEventRender to override the default event HTML if needed.
Oh sorry, the BeforeEventRender part only applies to the Pro edition.
The following tutorial shows how to create a weekly timetable using DayPilot Pro: