Re: listing data after a certain date

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)

This should work...

   Select name, ssn
   from junk
   where date > to_date('01-MAR-98','dd-MON-yy');  

> 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 CET