asked on

Convert Java LocalDate to date time stamp UTC format

My Entity Class AppAuthorization.java has the below column EFFECTIVE_START_DATE which is defined as EFFECTIVE_START_DATE DATE(8) NOT NULL column of APP_AUTHORIZATION Table in H2 DB

 @Column(name = "EFFECTIVE_START_DATE", nullable = false)
 private LocalDate effectiveStartDate;

Open in new window

My question is how can I save effectiveStartDate in UTC date time stamp format in APP_AUTHORIZATION Table using Java 8 ?

CEHJ

That's supported out of the box in JPA >= 2.2 and Hibernate >= 5.3 apparently

ronan_40060

ASKER

Thank you CEHJ ,
Im using below code to convert LocalDate to UTC datetime Stamp . Is this correct ?

appAuthorization.setEffectiveStartDate(LocalDate.now(ZoneOffset.UTC));

ASKER CERTIFIED SOLUTION

CEHJ

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ronan_40060

ASKER

even I found that Instant.now() can be used to get time in UTC format so which one is better ? This one or above
in my earlier post >

appAuthorization.setEffectiveStartDate(LocalDate.from(Instant.now()));

Open in new window

CEHJ

Hmm. I wonder what would happen if the 'system UTC' clock were not available with Instant.now()

ronan_40060

ASKER

looks like LocalDate.now(ZoneOffset.UTC) is a better solution

CEHJ

I'd guess, yes

ronan_40060

ASKER

is there any way to substract a milli second from

LocalDate.now(ZoneOffset.UTC)

Open in new window