LocalDateTime

LocalDateTime의 Format

1. DateTimeFormatter.ISO_DATE_TIME

- 2018-10-10T00:00:00.000+09:00

- 2018-10-10T00:00:00.000Z

2. 그밖의 format

- yyyyMMddHHmmss

- yyyy-MM-dd HH:mm:ss

- yyyy-MM-dd

LocalDateTime의 다양한 변환

1. LocalDateTime <-> sql.TimeStamp

import java.sql.Timestamp;

@Converter(autoApply = true)

public class LocalDateTimeConverter implements AttributeConverter<LocalDateTime, Timestamp> {

    @Override

    public Timestamp convertToDatabaseColumn(LocalDateTime localDateTime) {

        return (localDateTime == null) ? null : Timestamp.valueOf(localDateTime);

    }

    @Override

    public LocalDateTime convertToEntityAttribute(Timestamp sqlTimestamp) {

        return (sqlTimestamp == null) ? null : sqlTimestamp.toLocalDateTime();

    }

}

2. LocalDateTime <-> sql.Date

import java.sql.Date;

@Converter(autoApply = true)

public class LocalDateConverter implements AttributeConverter<LocalDate, Date> {

    @Override

    public Date convertToDatabaseColumn(LocalDate localDate) {

        return (localDate == null) ? null : Date.valueOf(localDate);

    }

    @Override

    public LocalDate convertToEntityAttribute(Date sqlDate) {

        return (sqlDate == null) ? null : sqlDate.toLocalDate();

    }

}

3. LocalDateTime <-> json

import com.fasterxml.jackson.core.JsonGenerator;

import com.fasterxml.jackson.databind.JsonSerializer;

import com.fasterxml.jackson.databind.SerializerProvider;

public final class LocalDateTimeJsonSerializer extends JsonSerializer<LocalDateTime> {

@Override

public void serialize(LocalDateTime value, JsonGenerator jgen, SerializerProvider provider) throws IOException {

jgen.writeString(DateTimeFormatter.ofPattern("yyyyMMddHHmmss").format(value));

}

}

import com.fasterxml.jackson.core.JsonParser;

import com.fasterxml.jackson.databind.DeserializationContext;

import com.fasterxml.jackson.databind.JsonDeserializer;

public final class LocalDateTimeJsonDeserializer extends JsonDeserializer<LocalDateTime> {

@Override

public LocalDateTime deserialize(JsonParser p, DeserializationContext ctxt) throws IOException {

return LocalDateTime.parse(p.getText(), DateTimeFormatter.ofPattern("yyyyMMddHHmmss"));

}

}

4. LocalDateTime <-> String

public LocalDateTime toLocalDateTime(DateTimeFormatter formatter, String localDateTime) {

return LocalDateTime.parse(localDateTime, formatter);

}

public String toString(DateTimeFormatter formatter, LocalDateTime localDateTime) {

return localDateTime.format(formatter);

}

5. LocalDateTime <-> millisecond

public LocalDateTime toLocalDateTime(Long millisecond) {

return Instant.ofEpochMilli(millisecond).atZone(ZoneId.systemDefault()).toLocalDateTime();

}

public Long toEpochMillis(LocalDateTime localDateTime) {

return localDateTime.atZone(ZoneId.systemDefault()).toInstant().toEpochMilli();

}