How to convert PostgreSQL timestamp with time zone to DateTime?

Question

This is a date which I get in my application:

String psqlDate = "2013-11-17 14:08:33+01";

What is the best way to convert psqlDate to joda DateTime?

[EDIT]

I can use the DateTime parse method. It works fine with a timestamp in which I have splitted information about date and time with T - 2013-11-17T14:08:33+01.

This should work with the following pattern:

DateTimeFormatter formatter = DateTimeFormat.forPattern("yyyy-MM-dd...");
DateTime dt = DateTime.parse((String) obj, formatter);

What is the correct pattern for a PostgreSQL timestamp with time zone?

Answer 1

Here a genuine Joda answer. Have you tried following pattern in org.joda.time.format.DateTimeFormat?

"yyyy-MM-dd HH:mm:ssZ"

I see that your time zone offset is only specified in hours, not minutes. So maybe you need simple preprocessing and double Z like this:

String psqlDate = "2013-11-17 14:08:33+01";
DateTimeFormatter formatter = DateTimeFormat.forPattern("yyyy-MM-dd HH:mm:ssZZ");
DateTime dt = DateTime.parse(psqlDate + ":00", formatter);

Answer 2

you can try this

    String psqlDate = "2013-11-17 14:08:33+01";
    Date date=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss'+'01").parse(psqlDate);
    System.out.println(date);

Out put:

    Sun Nov 17 14:08:33 IST 2013