Обсуждение: Hour records within a date range

Поиск
Список
Период
Сортировка

Hour records within a date range

От
sconeek@gmail.com
Дата:
hi all,
i am trying to take a datefrom and dateto from a user and insert all
hour records within that date range within the db. eg, if the user
selects 2006-03-14 as datefrom and 2006-03-14 as dateto, the system
would insert 24 rows within the table with their corresponding
timestamps (eg 2006-03-14 01:00:00....2006-03-14 23:00:00).
any suggestions on how to do this. thanks.