Forum Discussion

mallikarjun9685's avatar
mallikarjun9685
New Member
5 years ago

Time data type giving error

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,whe...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

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-TYPEOF-while-using-the-TYPEOF-Function

https://community.snowflake.com/s/question/0D50Z00008wRO7t/what-does-this-error-message-mean-invalid-argument-types-for-function-get-varchar16777216-varchar15-loading-csv-file-from-azure-blob

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.