I'm trying to convert the date field from YYYY-MM-DD HH:MM:SS:MS to MM/DD/YYYY format in a view using Snowflake database with below condition: TO_VARCHAR(DATE(SRC_DATE),'MM/DD/YYYY') I'm able to convert the date to expected format with above condition, but when I try to…
I have a table like sales(product_number, assortment, date) Here 1 assortment contains multiple products. For example 1 assortment i.e. chocolates contains product_number cadbury, 5 star, kitkat etc. Each and every product has date. I'm trying to check that all products…
I have a case statement to rectify one business logic in snowflake: INSERT INTO DB.table_b SELECT CASE WHEN UPPER(emp) <> LOWER(emp) THEN NULL WHEN emp IS NULL THEN nullif(emp, 'NULL') ELSE emp END AS emp_no FROM DB.table_a; The 'table_a' content…