Re: ok, i need help
Date: Sun, 11 Feb 2001 17:34:19 GMT
Message-ID: <v2Ah6.1252$8o4.175969_at_monger.newsread.com>
Also in the case you sent you have a syntax error in
to_date('22-Jun-2005 dd-mon-yyyy').
A useful technique is to select from dual to help pin down errors. For example:
select to_date('22-Jun-2005 dd-mon-yyyy') from dual;
*
ERROR at line 1:
ORA-01830: date format picture ends before converting entire input string
Then if you get an error you can post it to the group along with the problem and have a better chance of getting an answer to the problem. And Sybrand is right - if you're going to work with databases, you'll have to learn SQL whether the professor teaches it or not. The quicker, the better.
Van
"Jerry Parmeley" <jparmeley_at_hotmail.com> wrote in message
news:t8c28e88145l8b_at_corp.supernews.com...
> everyone out there in sql land, i need help.
> for a school project we are creating a airline company database.
> this database should include airports (5), jets (3), passengers (20), and
> flights (20-arriving and departing).
> i have created the data within the database; however, i can not get select
> statements to work. simple statements like selecting column from table no
> problem. but when it come to complex statements it won't work for me. i
> guess i am not getting the idea of joining. example select that returns
no
> rows
>
> select flightdepart_id, jet_id, airport_id
> from flightdepartureinfo
> where flightdepartdaytime = to_date('22-Jun-2005 dd-mon-yyyy');
>
> doesn't work, i do have a flight that leaves on the 22 of june.
>
> i need some help, even the sql dummies book i bought isn't helping a whole
> lot of these silly joins. it would help if the teacher taught us sql, but
> he expects us to learn it ourselves.
>
> thanks for the help
>
> jerry
>
>
Received on Sun Feb 11 2001 - 18:34:19 CET