select based on date range
select based on date range
От:
"Erik B. Flitman" <erikf@syncc.com>
Дата:
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
Re: select based on date range
От:
Ken Kinder <ken@kenkinder.com>
Дата:
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 > >