/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 vote134 views1 answer
IM DEAD
TypeScript
0 vote129 views1 answer
Copy elements from one array to another java
TypeScript
1 vote121 views1 answer
How to add elements to Jlist
TypeScript
3 votes132 views1 answer
Adonis validator opcional
TypeScript
10 votes129 views3 answers
Addeventlistener with arguments in angular 8
TypeScript
0 vote131 views1 answer
Angular cancel http request
TypeScript
2 votes122 views2 answers
How to input elements in list in python using for loop
TypeScript
1 vote119 views1 answer
Sass migrate division vue
TypeScript
0 vote115 views1 answer
Common child hackerrank solution
TypeScript
0 vote119 views1 answer
How to check if there is any point which lies inside the circle
TypeScript