/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 votes135 views1 answer
Find total commits in git
TypeScript
0 vote167 views1 answer
After effects how to parent only one property
TypeScript
0 vote137 views1 answer
Inno add exe in service
TypeScript
0 vote140 views1 answer
How to compare two lists and return the number of times they match at each index in python
TypeScript
0 vote138 views1 answer
Interface with variable key typescript
TypeScript
1 vote199 views1 answer
'mat-label' is not a known element:
TypeScript
0 vote131 views1 answer
How to check if an element starts with class in jquery
TypeScript
4 votes127 views2 answers
How to add a new propety into all documents in mongodb
TypeScript
1 vote131 views1 answer
Typescript filter undefined
TypeScript
4 votes139 views2 answers
C# merge two lists different types
TypeScript