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
Closed

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

simonw opened this issue Apr 24, 2018 · 0 comments

Comments

@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 as completed in 97f2f74 Apr 24, 2018
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

1 participant