How to get time from db depending upon conditions
- by Somebody is in trouble
I have a table in which the value are
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
Now i want to select date
in days if it is 3 days before or less
in hours if it is 24 hours before or less
in minutes if it is 60 minutes before or less
in seconds if it is 60 seconds before or less
in simple format if it is before 3days or more
OUTPUT
for row1 2012-01-31 23:01:01
for row2 1 day ago
for row3 1 hour ago
UPDATE
My sql query
select case
when TIMESTAMPDIFF(SECOND, `date`,current_timestamp) <= 60
then concat(TIMESTAMPDIFF(SECOND, `date`,current_timestamp), ' seconds')
when TIMESTAMPDIFF(DAY, `date`,current_timestamp) <= 3
then concat(TIMESTAMPDIFF(DAY, `date`,current_timestamp), ' days')end
when TIMESTAMPDIFF(HOUR, `date`,current_timestamp) <= 60
then concat(TIMESTAMPDIFF(HOUR, `date`,current_timestamp), ' hours')
when TIMESTAMPDIFF(MINUTE, `date`,current_timestamp) <= 60
then concat(TIMESTAMPDIFF(MINUTE, `date`,current_timestamp), ' minutes')
from table_hello
Only problem is i am unable to use break and default in sql like switch case in c++
