/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 vote159 views1 answer
Block robots from crawling
TypeScript
4 votes154 views4 answers
Array.prototype.map() expects a return value from arrow function array-callback-return
TypeScript
0 vote168 views2 answers
Typescript type number range
TypeScript
0 vote175 views1 answer
Making barplots in r
TypeScript
35 votes161 views2 answers
Typescript last index of array
TypeScript
0 vote147 views1 answer
Nativescript date input validation
TypeScript
1 vote153 views3 answers
An attempt was made to access a socket in a way forbidden by its access permissions
TypeScript
0 vote166 views2 answers
Add redux to react typescript
TypeScript
-1 vote205 views1 answer
Git command to check for any conflicts between new and old versions on your repository
TypeScript
0 vote160 views2 answers
Window.print div
TypeScript