strptime binder error

Binder Error: No function matches the given name and argument types

In DuckDB version 0.10 a breaking change was made to no longer implicitly cast during function binding. Below we show options to fix this.

I was importing a CSV file and converting a column named DT to an actual date, when loading the CSV duckdb inferred the column as being numeric. The change means that the strptime function no longer works against the numeric column, it expects a varchar.

INSERT INTO table SELECT cast(strptime("DT", '%Y%m%d') AS DATE) AS dt, * FROM read_csv_auto('*.csv');

Option 1 - Cast to ::STRING

Add ::STRING to the first argument to strptime, this will convert it to string before the call:

INSERT INTO table SELECT cast(strptime("DT"::STRING, '%Y%m%d') AS DATE) AS dt, * 
    FROM read_csv_auto('*.csv');

Option 2 - Specify the type when loading the CSV

Add types={"DT": "STRING"} to the read csv call.

INSERT INTO table SELECT cast(strptime("DT"::STRING, '%Y%m%d') AS DATE) AS dt, * 
    FROM read_csv_auto('*.csv', types={"DT": "STRING"});