Get UnixTimeStamp in Java
Current UnixTimeStamp: long currentUnixTimestamp = System.currentTimeMillis()/1000; In MYSQL: 1) From date to UnixTimestamp: SELECT UNIX_TIMESTAMP('2012-12-27 08:03:00'); 2) From UnixTimeStamp to date: SELECT FROM_UNIXTIME(1356618379);