/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 vote254 views1 answer
Error: Missing "key" prop for element in iterator
TypeScript
1 vote248 views2 answers
Common legend for multiple plots in r
TypeScript
0 vote247 views1 answer
Dart exit loop
TypeScript
-1 vote241 views3 answers
Lodash merge array of objects without duplicates
TypeScript
-1 vote223 views1 answer
2d array of strings and ints python
TypeScript
7 votes202 views5 answers
Firebase: Firebase App named '[DEFAULT]' already exists (app/duplicate-app).
TypeScript
0 vote232 views1 answer
Angular currency pipe pt-br as variable
TypeScript
0 vote256 views1 answer
Hide elements in 2s jquery
TypeScript
0 vote262 views1 answer
Config all requests to one page nginx
TypeScript
6 votes239 views1 answer
Angular devkit build angular error
TypeScript