How to format a java.sql Timestamp for displaying?

java datetime formatting
nos picture nos · Jul 21, 2009 · Viewed 266.2k times · Source

How do I formate a java.sql Timestamp to my liking ? ( to a string, for display purposes)

Answer

ChssPly76 picture ChssPly76 · Jul 21, 2009

java.sql.Timestamp extends java.util.Date. You can do: 

String s = new SimpleDateFormat("MM/dd/yyyy").format(myTimestamp);

Or to also include time:

String s = new SimpleDateFormat("MM/dd/yyyy HH:mm:ss").format(myTimestamp);

Related questions

Convert Date/Time for given Timezone - java

I want to convert this GMT time stamp to GMT+13: 2011-10-06 03:35:05 I have tried about 100 different combinations of DateFormat, TimeZone, Date, GregorianCalendar etc. to try to do this VERY basic task. This code does what I want for the …

Read More
Using Alphabetic Characters in SimpleDateFormat Pattern String

Is it possible to include an alphabetic character in a SimpleDateFormat Pattern String? I am trying to create a format string where the letter 'T' is included before the time for example: 2003-11-15T09:30:47-05:00. I am currently using …

Read More
How do I format a javax.time.Instant as a string in the local time zone?

How do I format a javax.time.Instant as a string in the local time zone? The following translates a local Instant to UTC, not to the local time zone as I was expecting. Removing the call to toLocalDateTime() does …

Read More