Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 759
  • Last Modified:

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
0
Farzad Akbarnejad
Asked:
Farzad Akbarnejad
1 Solution
 
slightwv (䄆 Netminder) Commented:
Add the format mask:

to_date('15-Sep-2012 10:30 AM','DD-Mon-YYYY HH:MI:SS AM')
0
 
Farzad AkbarnejadAuthor Commented:
Great, Thanks for your quick response.

-FA
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Tackle projects and never again get stuck behind a technical roadblock.
Join Now