java.sql.Timestamp类的使用

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);
	}
}




©️2020 CSDN 皮肤主题: 大白 设计师:CSDN官方博客 返回首页