/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 vote281 views1 answer
Number of vibrations per second is called
TypeScript
0 vote314 views1 answer
Angular output send click event to parent
TypeScript
2 votes296 views1 answer
Adonis model preload with condition
TypeScript
0 vote284 views2 answers
List of continents
TypeScript
0 vote240 views1 answer
Allow specific string in type
TypeScript
0 vote290 views1 answer
How to combine pdf documents C#
TypeScript
25 votes266 views10 answers
Github
TypeScript
1 vote258 views1 answer
How to make an element be above all the other elements html
TypeScript
1 vote284 views1 answer
How to pring events in pygame
TypeScript
1 vote285 views2 answers
Typescript declare process.env
TypeScript