UNIX for Beginners Questions & Answers

select call_start_time from call_detail_records
 where call_start_time IN (
   select from_unixtime(call_start_time) from call_detail_records
    where from_unixtime(call_start_time) < Now()
    and from_unixtime(call_start_time) < DATE_ADD(Now(),INTERVAL- 12 MONTH)
   );

from_unixtime(call_start_time) < DATE_ADD(Now(),INTERVAL- 12 MONTH) )

from_unixtime(call_start_time) > DATE_ADD(Now(),INTERVAL- 12 MONTH) )

from_unixtime(call_start_time) < Now()

SELECT call_start_time 
FROM   call_detail_records 
WHERE From_unixtime(call_start_time) > Date_add(Now(), interval - 12 MONTH) 
;