/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 vote371 views1 answer
Keyboard events pygame
TypeScript
0 vote341 views1 answer
Running same test in different environment
TypeScript
0 vote338 views1 answer
Python append elements from one list to anoter
TypeScript
4 votes410 views10 answers
Array
TypeScript
0 vote344 views1 answer
Declaring window object in ts
TypeScript
0 vote314 views1 answer
Laravel middleware for apis
TypeScript
0 vote322 views1 answer
Can we do system testing at any stage
TypeScript
0 vote335 views1 answer
Custom events in unity c#
TypeScript
0 vote409 views1 answer
Where do you store your test data
TypeScript
0 vote343 views1 answer
Display Popular Posts laravel
TypeScript