Oracle Date Comparsion

I have a column in TableA which contains date as Varchar2 datatype for column Start_date.( ‘2011-09-17:09:46:13’).

Now what i need to do is , compare the Start_date of TableA with the SYSDATE, and list out any values thts atmost 7days older than SYSDATE.

Can any body help me with this isssue.

Source: sql

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.