I have a simple spring boot REST API application, using plain jdbc to fetch data from a MSSQL DB. I am trying to figure out how best to retrieve a DATETIME2 column from the DB (which stores no timezone info), and serialize it as a UTC timestamp (and treat it as such in general in code). My DB server timezone
Tag: java.time.instant
Parse string with offset to Instant Java 11
I am trying to parse the following string 2021-10-15T08:39:05+02:00 into an Instant this works seamlessly using Java 15 but throws an error for Java 11. java.time.format.DateTimeParseException: Text ‘2021-10-19T11:06:35+02:00’ could not be parsed at index 19 Why is that the case? Edit: Java 15 Ans…
Java Instant.parse cannot validate date
I have an instant field and trying to validate the values in this field using the following approach: Instant.parse(“2021-09-29 09:35:07.531”) However, it throws the error: java.time.format.DateTimeParseException: Text ‘2021-09-29 09:35:07.531’ could not be parsed at index 10. So, how …
Java DateTimeFormatter Month Of Year Format
I am trying to convert an Instant to a String with the format like “10 Jul 2021, 10:00 PM”. It works as expected on my machine, but it comes out as “10 7 2021, 10:00 PM” in other environments. Answer Use MMM for month abbreviation and specify desired locale Output: 10 Jul 2021, 10:00 P…
Converting from Instant to XMLGregorianCalendar and vice-versa without losing precision
Using, java.time.Instant and javax.xml.datatype.XMLGregorianCalendar, I’m trying to convert from one to the other without losing precision. Why is this test not passing and how to fix it? Answer Why is this test not passing? Your XMLGregorianCalendar has got the full precision of your Instant. It’s your…
Converting string to ‘Instant’
I am trying to convert datetime in a string to an Instant instance using Java 8 or a utilities package. For example, to reqString is in the America/Toronto time zone. This is what I tried The above code results in “2018-05-12T23:30:00Z”. How can I do it? Answer tl;dr Fix your formatting pattern fo…
Convert java.time.Instant to java.sql.Timestamp without Zone offset
In the application I am developing, I need to convert java.time.Instant object to java.sql.Timestamp. When I create Instant object like: I receive something like 2017-03-13T14:28:59.970Z. And when I try to create Timestamp object like this: I receive something like 2017-03-13T16:28:59.970Z. The same result bu…