有关Spring 返回 json数据类型不一致（日期转long类型）在配置文件不能生效解决方法

开发中遇到个问题，明明后端接口debug返回的是java.sql.Timestamp
但是swagger上看却是long类型的
网上大多是通过增加application配置，但并不能解决问题

spring:
  jackson:
    date-format: yyyy-MM-dd HH:mm:ss
    time-zone: GMT+8

经过测试发现,需要修改JSON序列化配置，增加个转换类
原先碰到过clickhouse的数组类型java无法序列化也是这么解决的

import com.fasterxml.jackson.core.JsonGenerator;
import com.fasterxml.jackson.core.JsonParser;
import com.fasterxml.jackson.core.JsonProcessingException;
import com.fasterxml.jackson.core.TreeNode;
import com.fasterxml.jackson.databind.DeserializationContext;
import com.fasterxml.jackson.databind.DeserializationFeature;
import com.fasterxml.jackson.databind.JsonDeserializer;
import com.fasterxml.jackson.databind.JsonSerializer;
import com.fasterxml.jackson.databind.ObjectMapper;
import com.fasterxml.jackson.databind.SerializationFeature;
import com.fasterxml.jackson.databind.SerializerProvider;
import com.fasterxml.jackson.databind.module.SimpleModule;
import com.fasterxml.jackson.databind.node.ArrayNode;
import com.fasterxml.jackson.databind.node.TextNode;
import com.fasterxml.jackson.databind.ser.std.DateSerializer;
import com.fasterxml.jackson.datatype.jsr310.JavaTimeModule;
import lombok.SneakyThrows;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;
import org.springframework.http.converter.HttpMessageConverter;
import org.springframework.http.converter.json.Jackson2ObjectMapperBuilder;
import org.springframework.http.converter.json.MappingJackson2HttpMessageConverter;
import org.springframework.web.servlet.config.annotation.WebMvcConfigurer;
import ru.yandex.clickhouse.ClickHouseArray;
import com.fasterxml.jackson.databind.ser.std.ToStringSerializer;
import java.io.IOException;
import java.math.BigDecimal;
import java.math.BigInteger;
import java.sql.Timestamp;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;

@Configuration
public class WebMvcConfiguration implements WebMvcConfigurer {
    @Override
    public void configureMessageConverters(List<HttpMessageConverter<?>> converters) {
        converters.add(mappingJackson2HttpMessageConverter());
        WebMvcConfigurer.super.configureMessageConverters(converters);
    }

    @Bean
    public MappingJackson2HttpMessageConverter mappingJackson2HttpMessageConverter() {
        MappingJackson2HttpMessageConverter jsonConverter = new MappingJackson2HttpMessageConverter();
        //设置解析JSON工具类
        ObjectMapper objectMapper = new ObjectMapper();

        //解决空属性报错
        objectMapper.configure(SerializationFeature.FAIL_ON_EMPTY_BEANS, false);
        //忽略未知属性 防止解析报错
        objectMapper.configure(DeserializationFeature.FAIL_ON_UNKNOWN_PROPERTIES, false);

        // 全局clickhouseArray序列化配置
        SimpleModule module = new SimpleModule();
        //clickhouse Array 类型序列化
        module.addSerializer(ru.yandex.clickhouse.ClickHouseArray.class,new ClickHouseArraySerialize());
        //时间日期类型序列化
        module.addSerializer(Date.class, new DateSerializer(false,new SimpleDateFormat("yyyy-MM-dd")));
        module.addSerializer(Timestamp.class, new DateSerializer(false,new SimpleDateFormat("yyyy-MM-dd HH:mm:ss")));

        objectMapper.registerModule(module);
        objectMapper.findAndRegisterModules();
        jsonConverter.setObjectMapper(objectMapper);
        return jsonConverter;
    }


    public class ClickHouseArraySerialize extends JsonSerializer<ClickHouseArray> {
        @SneakyThrows
        @Override
        public void serialize(ClickHouseArray clickHouseArray, JsonGenerator jsonGenerator, SerializerProvider serializerProvider) throws IOException {
            // 对象转为字节流
            jsonGenerator.writeStartObject();
            jsonGenerator.writeStringField("elementType",clickHouseArray.getBaseTypeName());
            jsonGenerator.writeObjectField("array",clickHouseArray.getArray());
            jsonGenerator.writeEndObject();
        }
    }


}

加上之后就正常了