Weekday or hour fields

Hi all
I am trying to build a table that one of its columns is a week day and
another is an hour in the day.
The create_table syntax enables one only to determine a datetime or time
column which contain too much data
Any ideas as to how it can be done?
At the moment I use “string” for both columns.
Thanks
Danny

you could use ints for both… ruby Time.wday will give you the day of
week, with Sunday being 0

On Oct 14, 3:16 pm, Danny Y. [email protected]