List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:November 22 2001 10:35pm
Subject:RE: opinion - voating
View as plain text  
At 12:45 PM -0500 11/21/01, Auri Net SAC wrote:
>Hi
>
>it is possible
>
>"select * from table where col1 <= now and col2>=now"
>
>where col1 and col2 are date type
>
>thnaks

Yes, except that it should be now() rather than now.
Thread
• opinion - voatingMamun Murtaza Sheriff22 Nov
  • Re: opinion - voatingKen Kinder26 Nov
    • RE: opinion - voatingLuis Ferro26 Nov
    • Re: opinion - voatingNeil Zanella26 Nov
      • Re: opinion - voatingGordan Bobic26 Nov
      • Re: opinion - voatingHarald Fuchs27 Nov
• RE: opinion - voatingAuri Net SAC22 Nov
  • RE: opinion - voatingPaul DuBois22 Nov
• Re: opinion - voatingRobert Cross27 Nov