Re: select based on date range

From: Ken Kinder <ken(at)kenkinder(dot)com>
To: "Erik B(dot) Flitman" <erikf(at)syncc(dot)com>
Cc: pgsql-admin(at)postgreSQL(dot)org
Subject: Re: select based on date range
Date: 2000-08-15 00:55:54
Message-ID: Pine.LNX.3.96.1000814185503.1014A-100000@rage.x13.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

select * from foo where col > datetime 'date literal' and col < datetime
'date literal'

datetime 'value'

casts the string to a datetime variable. You can also use timespans.

--
Ken Kinder
www.kenkinder.com

On Mon, 14 Aug 2000, Erik B. Flitman wrote:

> Is there a quick way to select based on a date range. For example I want
> all records that have a date greater than the current date but go out only
> as far as 1 week.
>
> Sync Consulting, LLC
> Erik B. Flitman
> Vice President
>
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Geoffrey Gifford 2000-08-15 16:17:22 DBI & DBD-Pg
Previous Message Erik B. Flitman 2000-08-15 00:25:20 select based on date range