Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Date format issue #69

Open
YipingXiongTG opened this issue Aug 23, 2023 · 2 comments
Open

Date format issue #69

YipingXiongTG opened this issue Aug 23, 2023 · 2 comments

Comments

@YipingXiongTG
Copy link

Date with a precision of milliseconds, encoded as a string with the following format: yyyy-mm-ddTHH:MM:ss.sss+0000.
However, some date formats in the generated data do not meet the requirements.
截屏2023-08-23 15 06 14

@qishipengqsp
Copy link
Contributor

qishipengqsp commented Aug 23, 2023

It's probably an issue caused by the epoch_ms() function from DuckDB
https://github.com/ldbc/ldbc_finbench_datagen/blob/main/transformation/snapshot.sql#L23

Will fix in the next iteration

@Sanchez2020
Copy link

Date with a precision of milliseconds, encoded as a string with the following format: yyyy-mm-ddTHH:MM:ss.sss+0000. However, some date formats in the generated data do not meet the requirements. 截屏2023-08-23 15 06 14

The data type of the penultimate column should also be DateTime,right?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants