获取当前时间的时间戳

获取当前时间的时间戳

• Java

import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringRunner;

import java.util.Date;

@SpringBootTest
@RunWith(SpringRunner.class)
public class Demo {
    /**
     * 精确到秒
     */
    @Test
    public void run() {
        int i = (int) (System.currentTimeMillis() / 1000);
        System.out.println(i);
    }

    /**
     * 精确到毫秒
     *
     * @param date
     * @return
     */
    public static Long getTimestamp(Date date) {
        if (null == date) {
            return (long) 0;
        }
        String timestamp = String.valueOf(date.getTime());
        return Long.valueOf(timestamp);
    }

    /**
     * 测试
     */
    @Test
    public void test() {
        System.out.println(getTimestamp(new Date()));
        run();
    }
}

1587958390026
1587958390

• MySQL

 SELECT unix_timestamp(now()) #秒

1587958437