search

marat-karimov / factotum

Factotum is a simple app designed to make it easier to work with a variety of data file formats.
https://factotum.id
MIT License
5 stars 0 forks source link

Date format for DuckDB #17

Open jhit opened 1 month ago

jhit commented 1 month ago

Hello.

I love the application, but I have one small issue. I need DuckDB because it can understand the "like" SQL command but when importing my CSV file DuckDB does not recognize the date format of my CSV file. I see that we can configure DuckDB to understand the date format properly: https://duckdb.org/docs/data/csv/auto_detection

Is there any way to configure the date format for file import in Factotum?

karmagen88 commented 1 month ago

Hi @jhit ! Could you please share a sample of the csv file you are trying to import?