Thanks for this, I can easily determine the number of records I want.
Andrew
On Tue, Jun 23, 2009 at 10:52 AM, Steve
Crawford wrote:
> Andrew Maclean wrote:
>>
>> Is this the best way of getting a table of hourly dates?
>>
>> -- How to generate a table of dates at hourly intervals between two da
Andrew Maclean wrote:
Is this the best way of getting a table of hourly dates?
-- How to generate a table of dates at hourly intervals between two dates.
-- select timestamp 'epoch' + generate_series * interval '1 second' as
dates from generate_series(extract(epoch from date_trunc('hour',
times
