Given 02-01-2006 to 02-28-2006, output all days.

From: Henry Ortega <juandelacruz(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Given 02-01-2006 to 02-28-2006, output all days.
Date: 2006-02-17 21:07:28
Message-ID: 2bffcc330602171307i4b0c523eveeb6e3e4ecf1f46f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Is there a real quick way to do a query that will show me all the dates
given a startdate and an end date?

Given: 02-01-2006 and 02-28-2006
it should give me:
02-01-2006
02-02-2006
...
...
02-27-2006
02-28-2006

Can this be done by a built-in function perhaps?

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Owen Jacobson 2006-02-17 21:14:46 Re: Given 02-01-2006 to 02-28-2006, output all days.
Previous Message Axel Straschil 2006-02-17 14:28:13 ORDER BY with LTREE