Time data type giving error

[mallikarjun9685]

Hi All,

I have a column Invoicecreatedtime the Data type of this column is Time in snowflake(source and direct query).

when i drag with invocieItem field(when summarized) then its showing up,when i select as don't summarize of Invocie Item getting the bellow error (right side of visual).

how to resolve it any idea!!

Regards

Mallikarjun

[Anonymous]

g

[Anonymous]

Hi @mallikarjun9685 

I guess when an expression is passed as an argument, it will not be explicitly cast to the Variant date type. I searched some related introductions ,maybe you can refer to them .

https://community.snowflake.com/s/article/SQL-compilation-error-Invalid-argument-types-for-function-...

https://community.snowflake.com/s/question/0D50Z00008wRO7t/what-does-this-error-message-mean-invalid...

https://docs.snowflake.com/en/sql-reference/functions/timestampdiff.html

Best Regards

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.