/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 votes329 views1 answer
What is the purpose of interrupts in os
TypeScript
0 vote338 views1 answer
Ts pipe function
TypeScript
20 votes302 views2 answers
Typescript how to color your console loggers
TypeScript
2 votes318 views1 answer
Adonis many to many
TypeScript
0 vote309 views6 answers
Python double check if wants to execute funtion
TypeScript
0 vote275 views1 answer
Form control adding disabled and validators
TypeScript
0 vote330 views1 answer
Components of cucumber bdd framework
TypeScript
7 votes299 views2 answers
Typescript axios
TypeScript
0 vote311 views2 answers
How to find geopoints radius in mongoose
TypeScript
1 vote379 views1 answer
Adonis query delete
TypeScript