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

-d / -dt options for parsing columns as dates #33

Closed
simonw opened this Issue Apr 24, 2018 · 0 comments

Comments

Projects
None yet
1 participant
@simonw
Copy link
Owner

simonw commented Apr 24, 2018

SQLite prefers yyyy-mm-dd style dates - it can then sort them easily plus it has date functions which know how to work with them.

csvs-to-sqlite should have arguments that let the user specify columns that are known to be dates (or datetimes). It can then parse those dates and output them in the preferred format.

https://github.com/scrapinghub/dateparser looks like a good library for this: it can handle date parsing across many different languages, making it a potentially better fit than http://dateutil.readthedocs.io/en/stable/parser.html

@simonw simonw closed this in 97f2f74 Apr 24, 2018

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.