alibaba/easyexcel

使用easyexcel的 @DateTimeFormat("yyyy-MM-dd HH:mm:ss")注解导出数据秒多一秒

Open

#3,419 opened on Aug 20, 2023

View on GitHub
 (2 comments) (0 reactions) (0 assignees)Java (7,599 forks)batch import
help wanted

Repository metrics

Stars
 (33,728 stars)
PR merge metrics
 (No merged PRs in 30d)

Description

数据库中的数据是时间戳类型的

image 实体类的时间类型是java.time.Instant转为Date类型带有毫秒，使用@DateTimeFormat( "yyyy-MM-dd HH:mm:ss")导出的excel文件中秒会出现+1的情况

目前是使用自定义的Converter来避免Date时间有毫秒时，excel文件出现+1秒的情况，是这个@DateTimeFormat注解的使用有问题吗？

Contributor guide

Research direction
Examine the @DateTimeFormat annotation's handling of Date objects with milliseconds in EasyExcel's converter. Check if the annotation truncates milliseconds or rounds them, causing the second to increment. Trace the conversion path from Date to Excel cell value.
Tech stack
java
Domain
backend
Issue type
Bug
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-3 hours
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
Active
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
Clear
Prerequisites
JavaEasyExcel
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
60