Link to home
Start Free TrialLog in
Avatar of Farzad Akbarnejad
Farzad AkbarnejadFlag for Iran, Islamic Republic of

asked on

Use timestamp in query

Hello,
I have the following query in oracle (PL/SQL):

select username, target, v.start_time, v.last_update_time, round(100*sofar/totalwork,2) as percent_, opname,
     time_remaining from sys.v_$session_longops v where
       start_time >= to_date('15-Sep-2012') order by username, start_time

I want to filter records than start_time > 15-Sep-2012 10:30 AM   but I don't know how to include time in above query.

Thanks for your help,
-FA
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Farzad Akbarnejad

ASKER

Great, Thanks for your quick response.

-FA