Re: listing data after a certain date

From: MarkP28665 <markp28665_at_aol.com>
Date: 1998/03/11
Message-ID: <19980311230301.SAA21603@ladder02.news.aol.com>#1/1

From dwarakv_at_hotmail.com >>
 I need to write a query which lists data after a certain date. <<

Try: Select name, ssn from junk

          where   date_col  >=   to_date('01-Mar-98 00:00:00',
                                                                'DD-Mon-YY

HH24:MI:SS');

Baring any obvious (to anyone but me) typos this should do it.

Good Luck.

Mark Powell -- Oracle 7 Certified DBA
- The only advice that counts is the advice that you follow so follow your own advice - Received on Wed Mar 11 1998 - 00:00:00 CST