Timezone issue in Spring Boot JPA application

Question

I am facing date time issue in my spring boot jpa application.

For example, In my database I have one column created_on which contains 2019-07-11 09:30:00 date. When I fetch this record through JPA it converts to UTC.
For example it converts 2019-07-11 09:30:00 into 2019-07-11 05:00:00.

My System time is in IST and date is saved in database in IST as well.

I am using mysql database.

In my Enitity

private Date createdOn;

Database column:

created_on timestamp

Service:

@Service
@Transactional(readOnly = true)
public class EntityTypeService {
  @Autowired
  private IEntityTypeRepository entityTypeRepository;

  public EntityType findById(Long id) {
    EntityType entityType = entityTypeRepository.findById(id).orElse(new EntityType());
    System.out.println(entityType.getCreatedOn());
    return entityType;
  }
}

Repository

@Repository
public interface IEntityTypeRepository extends CrudRepository<EntityType, Long> {
}

Date in database is 2019-07-11 09:30:00

But when I print it on service System.out.println(entityType.getCreatedOn()); it gives me 2019-07-11 05:00:00.

This is generic issue in my whole application.

Answer 1

After so much research I found the solution.

Actually issue was because of

spring.jpa.properties.hibernate.jdbc.time_zone=UTC

this property which I have set in my appication.properties.

When I removed this property everything works fine at the backend. Backend showing the perfect time which is available in database.

But now when response comes to frontend, at that time my date gets converted to UTC.

Like backend it's showing 2020-06-03 18:56:14.0 and when it comes to front end it converts to 2020-06-02T13:26:14.000+0000.

Which is also an issue for me.

So after some more research I found that Jackson by default converts all date to UTC when object send to frontend.

The solution to this problem is

spring.jackson.time-zone=IST

My Database and System timezone is IST so I have set IST to jackson timezone too which solves the problem.

Hope this answer may help someone.