Re: ok, i need help

From: Christopher Maher <ChristopherMaher_at_Hotmail.com>
Date: Tue, 13 Feb 2001 14:09:01 -0500
Message-ID: <3A89864C.893D136B_at_Hotmail.com>


Hi Jerry,

I am assuming that the field flightdepartdaytime was defined in your CREATE TABLE statement as datatype DATE. Recall that when you inserted records into this table, you needed to wrap your dates in single quotes. Always use single quotes when referring to dates as literals. In general, you do not need to use

the to_date conversion. Try:

select flightdepart_id, jet_id, airport_id   from flightdepartureinfo
  where flightdepartdaytime = '22-Jun-2005';

If you insist on using to_date, you need to correct your syntax. The to_date function takes two arguments, separated by a comma. Both arguments are strings

which must be enclosed in single quotes.

For example:

select flightdepart_id, jet_id, airport_id   from flightdepartureinfo
  where flightdepartdaytime = to_date('22-Jun-2005', 'dd-mon-yyyy');

Cheers

Chris Received on Tue Feb 13 2001 - 20:09:01 CET

Original text of this message