Re: listing data after a certain date

Try

SELECT name, ssn
FROM junk
WHERE date > TO_DATE('01-MAR-98');

Why while you using TO_NUMBER?

On Wed, 11 Mar 1998 15:50:10 -0600, dwarakv_at_hotmail.com wrote:

>Hi,
> I need to write a query which lists data after a certain date. The
>following query is what I have tried writing but have been unsuccessful with
>it.
>
> Select name, ssn
> from junk
> where date > to_number(1-MAR-98)
>
>The columns in the table are name varchar2(25)
> ssn number(9)
> date date
>
>I have tried the select statement without converting to a number format and
>the query doesn't work then either. Can someone out there help me with this
>query.
>
>Thanks
>Dwarak
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Thu Mar 12 1998 - 00:00:00 CST