/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

0 vote127 views1 answer
Conventional commits cheat sheet
TypeScript
0 vote142 views1 answer
When to choose automation over manual testing
TypeScript
1 vote120 views1 answer
Typescript json.parse
TypeScript
9 votes161 views3 answers
Typescript object to array
TypeScript
0 vote136 views1 answer
Explode() expects parameter 2 to be string, array given
TypeScript
0 vote128 views1 answer
Convert given seconds to space age on all planets of our solar system
TypeScript
11 votes128 views6 answers
Localstorage
TypeScript
0 vote127 views1 answer
Subscription' is deprecated
TypeScript
2 votes132 views2 answers
Key value typescript
TypeScript
0 vote137 views2 answers
List elements not in indices
TypeScript