Re: SQL to sellect a date

Brad McBride <Brad.McBride_at_Axom.com> 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.

Try it with "like" the date contains also the time:

  SELECT * FROM tktmaster
   WHERE opendate like TO_DATE('01/26/99', 'MM/DD/YY');

Johannes Received on Wed Jan 27 1999 - 08:23:22 CST