解决java.sql.Timestamp丢失精度的问题

解决java.sql.Timestamp丢失精度的问题

目录java.sql.Timestamp丢失精度需要重新补偿java.sql.Timestamp类的使用1. 获取当前时间2.String类型转换为Timestamp3.Timestamp转换为String类型

java.sql.Timestamp丢失精度

Timestamp的构造函数Timestamp(long time) 会丢失纳秒部分的精度

需要重新补偿

Timestamp t1 = Timestamp.valueOf("2019-12-13 15:19:53.2202080");

Timestamp t2 = new Timestamp(1576250393220208000L / 1000000L);

t2.setNanos((int) (1576250393220208000L % 1000000000L));

java.sql.Timestamp类的使用

Timestamp 可以精确到小数秒 一般存储的格式：2016-12-18 11:05:36.531

Timestamp 可以获取当前时间，也可以把字符串装换成Timestamp类型

1. 获取当前时间

@Test

public void getCurrentTime(){

//第一种

Date date = new Date();

Timestamp currentTime1 = new Timestamp(date.getTime());

System.out.println("currentTime1:"+currentTime1);

//第二种

Timestamp currentTime2 = new Timestamp(System.currentTimeMillis());

System.out.println("currentTime2:"+currentTime2);

}

2.String类型转换为Timestamp

@Test

public void stringConvertTimestamp(){

String timeStr = "2016-12-18 11:16:33.706";

Timestamp ts = Timestamp.valueOf(timeStr);

System.out.println(ts);

}

3.Timestamp转换为String类型

@Test

public void timestampConvertString(){

SimpleDateFormat sdf = new SimpleDateFormat("yyy-MM-dd HH:mm:ss");

Timestamp currentTime = new Timestamp(System.currentTimeMillis());

String timeStr = sdf.format(currentTime);

System.out.println(timeStr);

}

整个演示类的代码：

package com.demo;

import java.sql.Timestamp;

import java.text.SimpleDateFormat;

import java.util.Date;

import org.junit.Test;

public class DemoTimestamp {

@Test

public void getCurrentTime(){

//第一种

Date date = new Date();

Timestamp currentTime1 = new Timestamp(date.getTime());

System.out.println("currentTime1:"+currentTime1);

//第二种

Timestamp currentTime2 = new Timestamp(System.currentTimeMillis());

System.out.println("currentTime2:"+currentTime2);

}

@Test

public void stringConvertTimestamp(){

String timeStr = "2016-12-18 11:16:33.706";

Timestamp ts = Timestamp.valueOf(timeStr);

System.out.println(ts);

}

@Test

public void timestampConvertString(){

SimpleDateFormat sdf = new SimpleDateFormat("yyy-MM-dd HH:mm:ss");

Timestamp currentTime = new Timestamp(System.currentTimeMillis());

String timeStr = sdf.format(currentTime);

System.out.println(timeStr);

}

}

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。