Formatting timestamp in Java

by

Probably you’re looking at the String representation the Timestamp object gives in your database engine or its Java representation by printing it in the console using System.out.println or by another method. Note that which is really stored (in both Java side or in your database engine) is a number that represents the time since epoch (usually January 1st 1970) and the date you want/need to store.

You should not pay attention to the String format it is represented when you consume your Timestamp. This can be easily demostrated if you apply the same SimpleDateFormat to get a String representation of your timestamp object:

DateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String currentTime = df.format(new Date());
Timestamp timestamp = Timestamp.valueOf(currentTime)
//will print without showing the .x part
String currentTimeFromTimestamp = df.format(currentTime);

Anyway, if you want the current time, just create the Timestamp directly from the result of new Date:

Timestamp timestamp = new Timestamp(new Date().getTime());

More Related Contents:

  1. java.util.Date format SSSSSS: if not microseconds what are the last 3 digits?
  2. Java Android Calendar/DateFormat this format XXXXXXXX [closed]
  3. java.text.ParseException: Unparseable date: "Augu 16, 1979" [duplicate]
  4. How to parse/format dates with LocalDateTime? (Java 8)
  5. Java: Date from unix timestamp
  6. What is this date format? 2011-08-12T20:17:46.384Z
  7. Convert timestamp in milliseconds to string formatted time in Java
  8. How to parse date string to Date? [duplicate]
  9. Difference between java HH:mm and hh:mm on SimpleDateFormat
  10. java DateTimeFormatterBuilder fails on testtime [duplicate]
  11. Handling MySQL datetimes and timestamps in Java
  12. java parsing string to date
  13. How to format a Java string with leading zero?
  14. How to convert String to Date without knowing the format?
  15. Current time in microseconds in java
  16. Java: Convert String to TimeStamp
  17. Convert LocalDate to LocalDateTime or java.sql.Timestamp
  18. Convert java.time.Instant to java.sql.Timestamp without Zone offset
  19. Convert a String to Double – Java
  20. How to convert HH:mm:ss.SSS to milliseconds?
  21. ‘0000-00-00 00:00:00’ can not be represented as java.sql.Timestamp error
  22. How to convert byte array to hex format in Java
  23. Best way to convert Java SQL Date from yyyy-MM-dd to dd MMMM yyyy format
  24. Java Timestamp – How can I create a Timestamp with the date 23/09/2007?
  25. How can I parse/format dates with LocalDateTime? (Java 8)
  26. How to convert TimeStamp to Date in Java?
  27. The method format(String, Object[]) in the type String is not applicable for the arguments (…)
  28. SwingWorker not responding
  29. Setting a JPA timestamp column to be generated by the database?
  30. Using Struts2 Tags to Formatting Numbers

Leave a Comment