title: How Do I display current date and time in Toad for Oracle?
body: <p>I have a sql statement that counts the units(cable boxes) that were refurbished (had damaged parts replaced) and total units(cable boxes that just went through refurb and had nothing replaced) and it's supposed to do this count regularly (every time a unit is processed the count). Can someone please help me? Thank you.</p>
  
  <p>Justin</p>
  
  <p>Heres my sql code so far:</p>
  
  <p>SELECT COUNT(*) 
  FROM  cxadminn.repair_part<br>
  WHERE repair_type = 'REFURB' and created_date >?</p>