mukunku / ParquetViewer

Simple Windows desktop application for viewing & querying Apache Parquet files
GNU General Public License v3.0
783 stars 98 forks source link

[QUESTION] Query formatting #110

Closed MCRE-BE closed 5 months ago

MCRE-BE commented 6 months ago

Describe the question Dumb question, but has the datetime formatting changed? It only works for me when I input YYYY/MM/DD and not DD/MM/YYYY like in the wiki or the provided examples.

BTW, might be good to add a link in that dialog to the wiki :-) I only found that page when scanning through the issues.

Screenshots image

mukunku commented 6 months ago

Do you get any errors when you use the dd/mm/yyyy format in your queries?

Also, there's a link to the wiki in Help -> User Guide . However I'll think about how I can make sql details more discoverable 👍🏼

mukunku commented 6 months ago

After reading up on this some more, it seems only two date formats are supported: yyyy/MM/dd and the North American MM/dd/yyyy

Does that align with the behavior you are seeing?

MCRE-BE commented 6 months ago

only two date formats are supported: yyyy/MM/dd and the North American MM/dd/yyyy

Correct. It works for yyyy/MM/dd, while the example is dd/MM/yyyy 😇

mukunku commented 5 months ago

Addressed in #111