Re: listing data after a certain date
Date: 1998/03/11
Message-ID: <6e7rmd$o54$1_at_nnrp1.dejanews.com>#1/1
In article <6e70s0$48i$1_at_nnrp1.dejanews.com>,
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
G'day!
Try :
SELECT name, ssn
FROM junk
WHERE date > to_date('01-MAR-98','DD-MON-YY')
Since the default date format is DD-MON-YY, you could probablt just use WHERE date > '01-MAR-98'
That should work.
Stay Casual,
Ken
-----== 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