Invalid argument types for function SQL compilation error when passing parameter values to Snowflake Function

Question

I have create a function in Snowflake with two 'date'arguments:

CREATE OR REPLACE FUNCTION "fn_CreateHourLabels"(start_date date,end_date date)
    RETURNS TABLE ...

When I attempt to use the function:

SELECT * FROM TABLE("fn_CreateHourLabels"('2021-03-01','2021-03-11'))

I get the following error: SQL compilation error: error line 1 at position 20 Invalid argument types for function '"fn_CreateHourLabels"': (VARCHAR(10), VARCHAR(10))

I am assuming there is something simple I have missed. Is it because the I have declared the arguments as 'date' data types and the select statement is classifying my date values as strings?

Thanks in advance

Felipe Hoffa · Accepted Answer · 2021-03-13 01:50:38Z

4

Instead of

SELECT * 
FROM TABLE("fn_CreateHourLabels"('2021-03-01','2021-03-11'))

Call it like this, making sure that Snowflake recognizes those strings as dates:

SELECT * 
FROM TABLE("fn_CreateHourLabels"('2021-03-01'::date,'2021-03-11'::date))

answered Mar 13, 2021 at 1:50

Felipe Hoffa

59.8k23 gold badges185 silver badges365 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Invalid argument types for function SQL compilation error when passing parameter values to Snowflake Function

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related