Re: SQL to sellect a date

I believe the problem is the column opendate contains a time value other than 00:00:00 so you will have to use the TRUNC function to remove the time element e.g.

      TRUNC(opendate) = ...
or if open date has an index on it and you wish to use the index then use the between operator

e.g.

   opendate between to_date('01/26/1999 00:00:00','dd/mm/yyyy hh24:mi:ss') and to_dateto_date('01/26/1999 23:59:59','dd/mm/yyyy hh24:mi:ss')

Brad McBride wrote:

> Hi,
>
> I'm currently developing a database that our company will be using to
> power our internal helpdesk. The only thing that I have left to do is
> selecting tickets by date and by a date range. I tried the following
> command:
>
> SELECT * FROM tktmaster WHERE opendate=TO_DATE('01/26/99', 'MM/DD/YY');
>
> and did not get any rows back even though I knew that I should get at
> least 20 different rows. Have I done something wrong with the SQL or do
> I need to do something else in order to select specific tickets that
> were opened on a certain date.
>
> Thanks.
Received on Wed Jan 27 1999 - 08:46:52 CST