Thanks Pando. But this will return me the time that was half hour ago. I need this time to compare with column values of my table.

something like :

select * from trans_table where mod_date > sysdate - 1/48;

where mod_date is of type Datetime.

Do I need to use to_date function in SQL? or any other function?

I am not quite sure of syntax. So just wanted to make whether my syntax is right. I dont have sqlplus working in my machine and I need to help a friend who has asked me for this.

Thanks for the help.