title: How to get time from db depending upon conditions
body: <p>I have a table in which the value are</p>
  
  <pre><code>             Table_hello
  date                            col2
  2012-01-31 23:01:01             a
  2012-06-2  12:01:01             b
  2012-06-3  20:01:01             c
  </code></pre>
  
  <p>Now i want to select date </p>
  
  <ol>
  <li>in days if it is 3 days before or less</li>
  <li>in hours if it is 24 hours before or less</li>
  <li>in minutes if it is 60 minutes before or less</li>
  <li>in seconds if it is 60 seconds before or less</li>
  <li>in simple format if it is before 3days or more</li>
  </ol>
  
  <p>OUTPUT</p>
  
  <pre><code>for row1 2012-01-31 23:01:01 
  for row2 1 day ago 
  for row3 1 hour ago 
  </code></pre>
  
  <p>UPDATE
  My sql query</p>
  
  <pre><code>  select case 
              when TIMESTAMPDIFF(SECOND, `date`,current_timestamp) &lt;= 60 
              then concat(TIMESTAMPDIFF(SECOND, `date`,current_timestamp), ' seconds')
              when TIMESTAMPDIFF(DAY, `date`,current_timestamp) &lt;= 3 
              then concat(TIMESTAMPDIFF(DAY, `date`,current_timestamp), ' days')end
              when TIMESTAMPDIFF(HOUR, `date`,current_timestamp) &lt;= 60 
              then concat(TIMESTAMPDIFF(HOUR, `date`,current_timestamp), ' hours')
              when TIMESTAMPDIFF(MINUTE, `date`,current_timestamp) &lt;= 60 
              then concat(TIMESTAMPDIFF(MINUTE, `date`,current_timestamp), ' minutes')
  
  from table_hello
  </code></pre>
  
  <p>Only problem is i am unable to use break and default in sql like switch case in c++</p>