Joda DateTimeFormatter changing date while parsing

Question

I have a problem while using Joda DateTimeFormatter. Please help me out !!

This is how my Formatter looks like-

final static DateTimeFormatter inJodaFmter = DateTimeFormat.forPattern("YYYY-MM-DD HH:mm:ss");

I am making a JDBC call and getting date as a String.

resultSet.getString(10) is returning "2013-12-06 00:00:00"

However, while formatting it with Joda DateTimeFormatter it is changing as below.

inJodaFmter.parseLocalDateTime(resultSet.getString(10)) = (org.joda.time.LocalDateTime) 2013-01-06T00:00:00.000

which is wrong. Please suggest.

Answer 1

tl;dr

Use smart objects, not dumb strings.

java.time.LocalDateTime ldt = myResultSet.getObject( … , LocalDateTime.class )

java.time

FYI, the Joda-Time project is now in maintenance mode, with the team advising migration to the java.time classes. See Tutorial by Oracle.

With JDBC 4.2 and later, you can directly exchange java.time objects with your database via getObject & setObject methods. Use objects rather than mere strings to communicate with a database.

No zone

If drawing data from a column defined in a type similar to the standard TIMESTAMP WITHOUT TIME ZONE, use LocalDateTime class.

LocalDateTime ldt = myResultSet.getObject( … , LocalDateTime.class ) ;

UTC

If drawing data from a column defined in a type similar to the standard TIMESTAMP WITH TIME ZONE, use Instant class or ZonedDateTime class.

Instant instant = myResultSet.getObject( … , Instant.class ) ;

---

About java.time

The java.time framework is built into Java 8 and later. These classes supplant the troublesome old legacy date-time classes such as java.util.Date, Calendar, & SimpleDateFormat.

The Joda-Time project, now in maintenance mode, advises migration to the java.time classes.

To learn more, see the Oracle Tutorial. And search Stack Overflow for many examples and explanations. Specification is JSR 310.

Where to obtain the java.time classes?

• Java SE 8, Java SE 9, and later
  • Built-in.
  • Part of the standard Java API with a bundled implementation.
  • Java 9 adds some minor features and fixes.
• Java SE 6 and Java SE 7
  • Much of the java.time functionality is back-ported to Java 6 & 7 in ThreeTen-Backport.
• Android
  • Later versions of Android bundle implementations of the java.time classes.
  • For earlier Android, the ThreeTenABP project adapts ThreeTen-Backport (mentioned above). See How to use ThreeTenABP….

The ThreeTen-Extra project extends java.time with additional classes. This project is a proving ground for possible future additions to java.time. You may find some useful classes here such as Interval, YearWeek, YearQuarter, and more.

Answer 2

Resolved using pattern DateTimeFormat.forPattern("Y-M-d H:m:s")

Source - http://joda-time.sourceforge.net/apidocs/org/joda/time/format/DateTimeFormat.html

Answer 3

Also, you can try like this;

public class Test {
    static final String DATE_FORMAT = "yyyy-MM-dd HH:mm:ss";

    public static void main(String[] args) {
        String dateTime = "2013-12-06 00:00:00";
        DateTimeFormatter formatter = DateTimeFormat.forPattern(DATE_FORMAT);
        DateTime jodatime = formatter.parseDateTime(dateTime);
        System.out.println(jodatime);

    }
}