/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

-2 votes168 views5 answers
Could not find a declaration file for module 'module-name'. '/path/to/module-name.js' implicitly has an 'any' type
TypeScript
2 votes120 views1 answer
No suitable injection token for parameter 'path' of class 'BaseModel'
TypeScript
6 votes124 views2 answers
Get arguments from url flask
TypeScript
0 vote108 views1 answer
How many arguments does a call to the Math.sqrt method have?
TypeScript
24 votes111 views4 answers
Children type typescript react'
TypeScript
0 vote123 views1 answer
How to check whether url is responding or not in typescript
TypeScript
2 votes117 views2 answers
Simple firestore cloud function update document
TypeScript
1 vote121 views2 answers
Htmlspecialchars() expects parameter 1 to be string, object given
TypeScript
0 vote153 views1 answer
Loop trhough list of lists in python and find single elements
TypeScript
0 vote122 views1 answer
Depth-first search that chooses values for one variable at a time and returns when a variable has no legal values left to assign
TypeScript