Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Date problems

Re: Date problems

From: <dnotari_at_yahoo.com>
Date: Thu, 06 May 1999 16:03:12 GMT
Message-ID: <3738bcde.27573238@newshost.us.oracle.com>


Michael,
  try

   SELECT * from my_table
     where my_table.date_column between low_date_entered and     high_date_entered;

  Note that you will have to use for low_date_entered and    high_date_entered a date format mask.

Regards
Dante
On Thu, 06 May 1999 12:26:31 +0200, Michael Holm <datb9812_at_knold.ballehs.dk> wrote:

>Hey
>
>
>I'm working on a program which includes a date function. How do I
>select between to dates. Meaning: the user has to enter to dates and
>then select the data between the dates. My date function includes Name
>of the day.
>
>
>--Michael
Received on Thu May 06 1999 - 11:03:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US