title: Oracle SQR datediff, rounding off seconds, and type
body: <p>in Oracle SQR (please, I know how already in SQL, I'm asking about SQR syntax), how can I:
   - determine the "type" of a variable?  I can't find any "type" function
   - what is the data type returned by datediff()?
   - and finally, how do I round off to whole seconds the amount returned by 
   <code>datediff($date1, $date2,'MINUTE')</code>?</p>
  
  <p>Thanks in advance.  Searching for this has been a problem because I get back tons of SQL statements and results with square root functions.</p>