/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

1 vote119 views1 answer
What is test management review
TypeScript
0 vote172 views1 answer
Apexcharts pie chart colors
TypeScript
0 vote108 views1 answer
Nestjs fail on unknown properties
TypeScript
0 vote100 views1 answer
Typescript watch mood
TypeScript
0 vote109 views1 answer
Paginator
TypeScript
2 votes101 views1 answer
UseStae with array of strings typescript
TypeScript
0 vote116 views1 answer
Prisma schema example
TypeScript
1 vote107 views1 answer
Two plots side by side r
TypeScript
-1 vote102 views1 answer
How many continents are there
TypeScript
0 vote102 views1 answer
Typescript named return
TypeScript