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
>
>