/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 vote198 views1 answer
Typescript d ts meaning
TypeScript
0 vote172 views1 answer
Sr.No. 18, Plot No. 5/3, CTS No.205,Behind Vandevi Temple, Karvenagar, Pune, Maharashtra
TypeScript
0 vote174 views1 answer
Number_format() expects parameter 1 to be float, string given
TypeScript
11 votes176 views1 answer
Remove dots from ul li
TypeScript
0 vote191 views1 answer
.htaccess Preventing requests with invalid characters
TypeScript
0 vote198 views1 answer
Capitalize first letter of all word typescript
TypeScript
1 vote195 views1 answer
++i vs i++
TypeScript
1 vote225 views1 answer
Execute only one test spec with angular-cli (ng test)
TypeScript
1 vote193 views1 answer
Replace \n with breakline in type scripte
TypeScript
0 vote163 views1 answer
About half of divorced parents try to avoid each other after the divorce, creating a different set of rules for children to follow in each parent’s household. This type of parental interaction is called
TypeScript