select  from_unixtime(starttime/1000), from_unixtime(starttime/1000) + interval 1 year, unix_timestamp(from_unixtime(starttime/1000) + interval 1 year) * 1000 from dtab limit 10;
+-------------------------------+-------------------------------------------------+------------------------------------------------------------------------+
| from_unixtime(starttime/1000) | from_unixtime(starttime/1000) + interval 1 year | unix_timestamp(from_unixtime(starttime/1000) + interval 1 year) * 1000 |
+-------------------------------+-------------------------------------------------+------------------------------------------------------------------------+
| 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)