mysql bigint类型和datetime类型的转换

1. 1、bigint类型转换为datetime类型

2. -- 假设 1164691264437 是 Java 里的“日期时间”：即：自1970-01-01 00:00:00以来的毫秒数
   

3. /*
   

4. getTime
   

5. public long getTime()Returns the number of milliseconds since January 1, 1970, 00:00:00 GMT represented by this Date object. 
   

6. 
   

7. Returns:
   

8. the number of milliseconds since January 1, 1970, 00:00:00 GMT represented by this date.
   

9. */
   

10. mysql> select from_unixtime(1164691264437/1000);
    

11. +-----------------------------------+
    

12. | from_unixtime(1164691264437/1000) |
    

13. +-----------------------------------+
    

14. | 2006-11-28 13:21:04               |
    

15. +-----------------------------------+

         2、datetime类型转换为bigint类型

1. -- 假设 "2011-05-31 23:59:59" 是 Java 里的“日期时间”：即：自1970-01-01 00:00:00以来的毫秒数
   

2. 
   

3. 
   

4. mysql> select UNIX_TIMESTAMP('2011-05-31 23:59:59');
   

5. +-----------------------------------+
   

6. | from_unixtime(1306857599/1000) |
   

7. +-----------------------------------+      |