/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

3 votes218 views2 answers
Removing directories in linux
TypeScript
0 vote218 views3 answers
Overlayscrollbars-react
TypeScript
1 vote222 views1 answer
Js split string with emoji
TypeScript
0 vote205 views1 answer
Sum of bits calculator
TypeScript
1 vote214 views2 answers
Hosts path
TypeScript
0 vote197 views1 answer
ReturnType FunctionName(FormalParameterList) { Statements ; return ReturnValue; }
TypeScript
8 votes198 views3 answers
Update local angular cli
TypeScript
3 votes199 views6 answers
Get multiple inputs in python
TypeScript
11 votes297 views4 answers
If a class exists jquery
TypeScript
0 vote196 views1 answer
Property does not exist on type 'DefaultRootState'
TypeScript