Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: dates
"Silicon Knight" <SiliconKnight_at_hotmail.com> wrote:
>select * from table where initial_date < '01-Jan-99' and final_date >
>'01-Jan-99';
If in Access put #s around the date instead of '. For example: select * from table where initial_date < #01-Jan-99# and final_date #01-Jan-99#;
If not Access the look in the help for your particular environment. The ' delimiter is typically for text fields only.
Tony
http://www.granite.ab.ca/accsmstr.htm VolStar http://www.volstar.com Manage hundreds or
thousands of volunteers for special events. Received on Wed Jun 02 1999 - 20:08:26 CDT
![]() |
![]() |