listing data after a certain date

From: <dwarakv_at_hotmail.com>
Date: 1998/03/11
Message-ID: <6e70s0$48i$1@nnrp1.dejanews.com>#1/1

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 Wed Mar 11 1998 - 00:00:00 CST