title: Oracle max function on timestamp datatype
body: <p>I want to take a max date from a timestamp datatype in oracle</p>
  
  <p>my data look like this</p>
  
  <pre><code>id  updated_date
  --  -------------------
  1   2011-12-21 10:34:24 
  1   2011-12-21 09:52:15
  1   2011-12-21 10:02:49
  </code></pre>
  
  <p>Since all the date are same but timestamp is difference the max function bringing all the 3 rows instead i want to see the max date with latest timestamp for each ID like below</p>
  
  <pre><code>Select MAX(updated_date) update_date, id FROM id_table group by id;
  id  updated_date
  --  -------------------
  1   2011-12-21 10:34:24 
  </code></pre>
  
  <p>thanks in advance</p>
  
  <p>The table as 10000 plus rows, the data looks like below </p>
  
  <pre><code> id  updated_date
   --  -------------------
   1   2011-12-21 10:34:24 
   1   2011-12-21 09:52:15
   1   2011-12-21 10:02:49
   2   2011-13-21 10:34:24 
   2   2011-13-21 09:52:15
   2   2011-13-21 10:02:49
   3   2011-14-21 10:34:24 
   3   2011-14-21 09:52:15
   3   2011-14-21 10:02:49
  </code></pre>
  
  <p>On select i want to see 1 row per id no duplicates
   Select MAX(updated_date) update_date, id FROM id_table group by id;</p>
  
  <pre><code>id  updated_date
   --  -------------------
   1   2011-12-21 10:34:24 
   2   2011-13-21 10:34:24 
   3   2011-14-21 10:34:24 
  </code></pre>