Re: Can't figure this out

maybe the parens are bad, but also the to_date is wrong You say:
TO_DATE('12/6/2002 3:00:00 AM','mm/dd/yyyy hh:mi') and the date and the format mask don't match. (mask says up to minutes and date is up to seconds with am specifier. try: TO_DATE('12/6/2002 3:00:00 AM','m/d/yyyy hh:mi:ss am') Jim

--
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family.  Remove the negative part, keep the minus sign.  You can figure
it out.
"Kim Lord" <lordkimberly_at_comcast.net> wrote in message
news:a5bfca91.0301151328.3332a0ad_at_posting.google.com...


> Please help me figure out what is wrong with this sql statement:


>

> ORA-00907: missing right parenthesis

> SELECT INFO.VECTIME, RECS.LONGITUDE, RECS.LATITUDE, RECS.U, RECS.V,

> RECS.UPRIME, RECS.VPRIME FROM ((SELECT FK_VECTORID, LONGITUDE,

> LATITUDE, U, V, UPRIME, VPRIME FROM CODARVECTORDATARECS WHERE

> LONGITUDE BETWEEN -72.1104177493672 AND -71.8895822506328 AND LATITUDE

> BETWEEN 40.9166666666667 AND 41.0833333333333) RECS), ((SELECT

> VECTIME, VECTORID FROM CODARTOTVECINFO WHERE VECTIME BETWEEN

> TO_DATE('12/6/2002 1:00:00 AM','mm/dd/yyyy hh:mi') AND

> TO_DATE('12/6/2002 3:00:00 AM','mm/dd/yyyy hh:mi') AND

> FK_CODARREGIONID='UCONN') INFO) WHERE RECS.FK_VECTORID = INFO.VECTORID

> ORDER BY INFO.VECTIME

>

> Any help is greatly appreciated,

> Kim