1

Hello I have a problem with insert OffsetdateTime with correct timezone I have string 20110401000000000 then I do convertion to OffsetDateTime like this:

DateTimeFormatter dft =
                    new DateTimeFormatterBuilder()
                            .appendPattern("yyyyMMddHHmmss")
                            .appendValue(ChronoField.MILLI_OF_SECOND, 3)
                            .toFormatter();

            LocalDateTime dateTime = LocalDateTime.parse(pDateTimeString, dft);
            OffsetDateTime of = OffsetDateTime.of(dateTime, ZoneOffset.ofHours(1));

and I get 2011-04-01T00:00+01:00 - everything is good now I do insert to database

 ps.setObject(3,of);

and in my datebase I see

red is wrong

is it convert in cest

curiosity -------------

if date 2021-03-03T00:00+01:00

enter image description here

it is correct put in database

-- my settings of my connection

c.getDefaultTimeZone() -> Europa/Zurich

c.getSessionTimeZone() -> Europa/Zurich

Thank you for help

M.B
  • 134
  • 9

0 Answers0