Function EXTRACT does not support NUMBER(38,0) argument type in SnowFlake

0
votes

I am in the process of converting Custom SQL to Snowflake for use in a Tableau extract. Unfortunately, I keep getting the same error message after converting the code:

Function EXTRACT does not support NUMBER(38,0) argument type

It is UNION All Snowflake piece of code and I'm trying to get the correct answer. Any ideas!

1
snowflake-cloud-data-platform
you need to provide sample data and also your code – eshirvana

1 Answers

0
votes

from error message , extract function in snowflake only gets date, time, or timestamp as input argument and clearly you are passing an argument with NUMBER(38,0) data type

see : EXTRACT- snowflake documentation