/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 vote160 views1 answer
Reported error code “128” when it ended: Permission denied (publickey). fatal: Could not read from remote repository. Please make sure you have the correct access rights and the repository exists.
TypeScript
1 vote164 views1 answer
ERROR in ngcc is already running at process with id 8108. If you are running multiple builds in parallel then you should pre-process your node_modules via the command line ngcc tool before starting the builds;
TypeScript
0 vote152 views1 answer
Show scroll only when overflow
TypeScript
0 vote153 views1 answer
Get_refreshed_fragments too long to load
TypeScript
1 vote147 views1 answer
Material ui circular progress coor
TypeScript
5 votes154 views3 answers
CountDocuments mongoose
TypeScript
0 vote150 views1 answer
Install typescript mac
TypeScript
0 vote157 views1 answer
Type alias in typescript
TypeScript
1 vote149 views1 answer
Typescript filter undefined
TypeScript
1 vote112 views1 answer
Are loop increments private in openmp
TypeScript