Format java.sql.Timestamp into a String

Question

Is it possible to convert/format java.sql.Timestmap into a String that has the following format:

yyyyMMdd

I know that doing it with a String is fairly simple e.g:

String dateString = "2016-02-03 00:00:00.0";
Date date = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss.S").parse(dateString);
String formattedDate = new SimpleDateFormat("yyyyMMdd").format(date);

But, I have to work with the Timestamp object.

Answer 1

The java.sql.Timestamp extends java.util.Date, so you can format it exactly the same way:

String formattedDate = new SimpleDateFormat("yyyyMMdd").format(date);

Parsing is almost the same, you can construct it using its "millis" representation:

Timestamp timestamp = new Timestamp(new SimpleDateFormat("yyyyMMdd").parse(formattedDate).getTime());

Answer 2

You could do something like so:

Timestamp ts = ...;
Date date = new Date();
date.setTime(ts.getTime());
String formattedDate = new SimpleDateFormat("yyyyMMdd").format(date);

Answer 3

Using the (not so) new java.time package:

private static final DateTimeFormatter FORMATTER = DateTimeFormatter.ofPattern("yyyyMMdd");

String convert(Timestamp ts) {
    return ts.toLocalDateTime().format(FORMATTER);
}

Answer 4

Using www.joda.org/joda-time/

public static String timestampAsString(Timestamp timestamp) {
    return DateTimeFormat.forPattern("yyyyMMdd").print(timestamp.getTime());
}