/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

18 votes191 views3 answers
What is unit testing
TypeScript
0 vote169 views1 answer
Typescript "variable?: type" notation
TypeScript
0 vote196 views1 answer
Property does not exist on type 'DefaultRootState'
TypeScript
0 vote234 views1 answer
How to add 2 bind events on one button tkinteer
TypeScript
1 vote182 views1 answer
Dev/storage/logs" and its not buildable: Permission denied
TypeScript
11 votes204 views3 answers
Property 'active' has no initializer and is not definitely assigned in the constructor.ts(2564)
TypeScript
1 vote192 views1 answer
Ionic modal controller pass parameter
TypeScript
6 votes202 views4 answers
Data
TypeScript
0 vote206 views2 answers
Typescript array of mixed types
TypeScript
0 vote203 views1 answer
How to check string array is sorted or not in typescript
TypeScript