0

How do I change the date that displays as YYYYMMDD to YYYYMMDDHHMMSS+-ZZZZ?

Any help is greatly appreciated thanks!

NewBond007
  • 53
  • 1
  • 8
  • Please read [ask]. Post a [mcve] – OldProgrammer Dec 21 '21 at 17:23
  • [java.time.format.DateTimeFormatter](https://docs.oracle.com/en/java/javase/12/docs/api/java.base/java/time/format/DateTimeFormatter.html) – Abra Dec 21 '21 at 17:32
  • how do i use the format thats coming from the query? – NewBond007 Dec 21 '21 at 17:33
  • You might wanna look up [here](https://stackoverflow.com/questions/12503527/how-do-i-convert-the-date-from-one-format-to-another-date-object-in-another-form). Hope this is, what you're looking for :) – Springwolve Dec 21 '21 at 17:39
  • Column data type? – jarlh Dec 21 '21 at 17:41
  • Which dbms are you using? – jarlh Dec 21 '21 at 17:41
  • A real `date` or `timestamp` column does not have any format. So there is no such thing as "the format coming from a db query" as long as you properly retrieve the value using `getObject(..., LocalDate.class)` or `getObject(..., LocalDateTime.class)` or at least `getTimestamp()` or `getDate()` –  Dec 21 '21 at 20:53

0 Answers0