Re: [ADMIN] select based on date range

[Ken Kinder]

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