/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 vote182 views1 answer
Python requests header allow redirect false
TypeScript
0 vote198 views1 answer
Extends multiple class typescript
TypeScript
0 vote174 views1 answer
Split in angular 8
TypeScript
0 vote182 views1 answer
__redux_devtools_extension_compose__ typescript
TypeScript
-1 vote186 views1 answer
What are the components of the environment? Explain it along with the examples.
TypeScript
13 votes198 views4 answers
Change checkbox jquery alert
TypeScript
2 votes193 views1 answer
State in react typescript
TypeScript
0 vote175 views1 answer
Length functioni in typesrcipt
TypeScript
0 vote185 views1 answer
TypeError: key must be an instance of a class implements jwt.AbstractJWKBase
TypeScript
0 vote236 views1 answer
Marine traffic embeeded map in basic html
TypeScript