Hour records within a date range

From: sconeek(at)gmail(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: Hour records within a date range
Date: 2006-03-13 21:35:15
Message-ID: 1142285715.413656.39700@u72g2000cwu.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Browse pgsql-general by date

  From Date Subject
Next Message Michael Schmidt 2006-03-13 22:28:23 Re: Wisconsin Circuit Court Access (WCCA) on PostgreSQL
Previous Message Scott Marlowe 2006-03-13 21:26:30 Re: Wisconsin Circuit Court Access (WCCA) on PostgreSQL