/TypeScript/Mutiple date formats in snowflake during copy

Mutiple date formats in snowflake during copy

COPY INTO MY_TABLE (NAME, DOB, DOD, HAIR_COLOUR) 
FROM (
   SELECT $1, TO_DATE($2,'YYYYMMDD'), TO_DATE($3,'MM-DD-YYYY'), $4 
   FROM @MY_STAGE/mypeeps (file_format => 'MY_CSV_FORMAT') 
)
ON_ERROR = CONTINUE;

Source: stackoverflow.com

Similar codes

2 votes105 views2 answers
React native elements button with icon
TypeScript
0 vote110 views1 answer
Types and CoProducts in scala
TypeScript
0 vote148 views2 answers
From date and to date validation in angular 9
TypeScript
0 vote122 views3 answers
How to compare two lists element by element in python and return matched element
TypeScript
0 vote104 views1 answer
Pass command line arguments C#
TypeScript
-3 votes108 views3 answers
Ts warning Could not find a declaration file for module but runs
TypeScript
0 vote107 views1 answer
Regex exec returns null
TypeScript
0 vote119 views1 answer
Deep partial typescript
TypeScript
1 vote112 views1 answer
What is the name of belt around the orbits of earth and mars
TypeScript
1 vote109 views4 answers
How to execute scripts when a button gui is pressed roblox
TypeScript