/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 vote186 views1 answer
Local Variable in Jenkins
TypeScript
0 vote221 views1 answer
Tkinter widgets overview
TypeScript
0 vote263 views1 answer
Discord bot login
TypeScript
0 vote174 views1 answer
Input deno
TypeScript
0 vote176 views2 answers
Ng2003
TypeScript
0 vote198 views1 answer
Which of the following object types below cannot be replicated
TypeScript
0 vote209 views3 answers
Spade operator typescript
TypeScript
0 vote198 views1 answer
How to use client and webresource objects to do https call
TypeScript
0 vote198 views1 answer
Connect onboarding for custom accounts specify country
TypeScript
1 vote166 views1 answer
Microsoft outlook graph get events dates
TypeScript