Converting java.sql.timestamp to LocalDateTime and vice versa

LocalDateTimeJPAConverter.java

import java.sql.Timestamp;
import java.time.LocalDateTime;

import javax.persistence.AttributeConverter;
import javax.persistence.Converter;

@Converter(autoApply = true)
public class LocalDateTimeConverter implements AttributeConverter<LocalDateTime, Timestamp> {
    @Override
    public Timestamp convertToDatabaseColumn(LocalDateTime ldt) {
        return Timestamp.valueOf(ldt);
    }

    @Override
    public LocalDateTime convertToEntityAttribute(Timestamp ts) {
    	if(ts!=null){
    		   return ts.toLocalDateTime();
    	}
    	return null;
    }
}

Note that this will use the system default time zone. Alternative: LocalDateTime.ofInstant(new Instant(ts), ZoneId.of("UTC"));

Good