select starttime from dtab limit 10;
+---------------+
| starttime     |
+---------------+
| 1364684890000 |
| 1364685077000 |
| 1364685298000 |
| 1364685747000 |
| 1364685837000 |
| 1364685947000 |
| 1364686068000 |
| 1364686108000 |
| 1364686109000 |
| 1364686204000 |
+---------------+
10 rows in set (0.00 sec)


select  from_unixtime(starttime/1000), from_unixtime(starttime/1000) + interval 1 year, unix_timestamp(from_unixtime(starttime/1000) + interval 1 year) * 1000 as ts from dtab limit 10;
+-------------------------------+-------------------------------------------------+--------------------+
| from_unixtime(starttime/1000) | from_unixtime(starttime/1000) + interval 1 year | ts                 |
+-------------------------------+-------------------------------------------------+--------------------+
| 2013-03-31 00:08:10.0000      | 2014-03-31 00:08:10.0000                        | 1396217290000.0000 |
| 2013-03-31 00:11:17.0000      | 2014-03-31 00:11:17.0000                        | 1396217477000.0000 |
| 2013-03-31 00:14:58.0000      | 2014-03-31 00:14:58.0000                        | 1396217698000.0000 |
| 2013-03-31 00:22:27.0000      | 2014-03-31 00:22:27.0000                        | 1396218147000.0000 |
| 2013-03-31 00:23:57.0000      | 2014-03-31 00:23:57.0000                        | 1396218237000.0000 |
| 2013-03-31 00:25:47.0000      | 2014-03-31 00:25:47.0000                        | 1396218347000.0000 |
| 2013-03-31 00:27:48.0000      | 2014-03-31 00:27:48.0000                        | 1396218468000.0000 |
| 2013-03-31 00:28:28.0000      | 2014-03-31 00:28:28.0000                        | 1396218508000.0000 |
| 2013-03-31 00:28:29.0000      | 2014-03-31 00:28:29.0000                        | 1396218509000.0000 |
| 2013-03-31 00:30:04.0000      | 2014-03-31 00:30:04.0000                        | 1396218604000.0000 |
+-------------------------------+-------------------------------------------------+--------------------+
10 rows in set (0.00 sec)