/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

-1 vote181 views1 answer
Div resize event typescript
TypeScript
2 votes214 views3 answers
Angular typescript refresh page
TypeScript
2 votes199 views2 answers
Capacitor icon and splash
TypeScript
0 vote185 views1 answer
Property 'split' does not exist on type string
TypeScript
6 votes192 views2 answers
Ignore typescript error
TypeScript
0 vote158 views1 answer
GOOGLE SHEETS web scraping commodity prices 2021
TypeScript
0 vote202 views1 answer
Check if file exists on s3 python
TypeScript
2 votes197 views3 answers
Print array elements with space c++
TypeScript
0 vote178 views1 answer
Typescript exclamation mark
TypeScript
0 vote197 views1 answer
What are the common mistakes in testing
TypeScript