/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 vote170 views2 answers
Angular 8 ts refresh page
TypeScript
9 votes186 views3 answers
Typescript onclick event type props
TypeScript
1 vote171 views1 answer
Whats harry potter's house
TypeScript
0 vote177 views1 answer
Conventional commits cheat sheet
TypeScript
0 vote199 views1 answer
Install material ui typescript
TypeScript
0 vote162 views1 answer
Typescript class import csv file
TypeScript
0 vote168 views1 answer
What is the reason we are using properties file
TypeScript
0 vote160 views1 answer
What do you need local sccripts for
TypeScript
0 vote151 views6 answers
Python double check if wants to execute funtion
TypeScript
-1 vote150 views1 answer
Angular input change event datatype typescript
TypeScript