DuckDB STRFTIME arguments incorrectly ordered

[markhalonen]

Fully reproducible code snippet

import sqlglot
print(sqlglot.transpile("""

select strftime('%Y-%m-%d', current_timestamp)


""", read="sqlite", write="duckdb", pretty=True)[0])

produces

SELECT
  STRFTIME('%Y-%m-%d', CURRENT_TIMESTAMP)

but that fails on DuckDB with

duckdb> SELECT
   ...>   STRFTIME('%Y-%m-%d', CURRENT_TIMESTAMP)
   ...> ;
Binder Error: No function matches the given name and argument types 'strftime(STRING_LITERAL, TIMESTAMP WITH TIME ZONE)'. You might need to add explicit type casts.
        Candidate functions:
        strftime(DATE, VARCHAR) -> VARCHAR
        strftime(TIMESTAMP, VARCHAR) -> VARCHAR
        strftime(VARCHAR, DATE) -> VARCHAR
        strftime(VARCHAR, TIMESTAMP) -> VARCHAR

LINE 2:   STRFTIME('%Y-%m-%d', CURRENT_TIMESTAMP)
          ^

duckdb> 

Official Documentation

• DuckDB stftime https://duckdb.org/docs/sql/functions/dateformat.html