sql help please

Dec 25, 2013 6:21AM

Hi,

I've to delete data from one table depending on date column of the table,

I'm not able to construct the sql for that, I need to delete data inserted before 1st july 2013 and keep rest data.

below sql showing data of same group, not data inserted data after 1st july 2013.

please help me to construct the required sql.........

SQL> select to_char(SESSION_END, 'dd-mm-yyyy hh24:mi:ss') from session

where to_char(SESSION_END, 'dd-mm-yyyy hh24:mi:ss') > '01-07-2013 00:30:30'

and rownum <6 order by 1 desc;

TO_CHAR(SESSION_END

-------------------

22-09-2005 01:35:22

22-09-2005 01:29:56

21-09-2005 22:06:03

SQL Language (MOSC)