Re: SQL to sellect a date

Hi,

There's time in your opendate field. You can change your command by  SELECT * FROM tktmaster WHERE to_char(opendate,'MM/DD/YY') = '01/26/99';

Regards.

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 Fri Jan 29 1999 - 14:30:16 CST