/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

3 votes183 views1 answer
Aggregate in r
TypeScript
0 vote162 views1 answer
How to get all the points of the circufrence python
TypeScript
0 vote199 views2 answers
Python combine two lists into matrix
TypeScript
0 vote184 views2 answers
Kotlin get first n elements from list
TypeScript
0 vote172 views1 answer
How should a developer write unit tests for a private method in an apex class
TypeScript
0 vote173 views1 answer
Cannot find module 'angular-imask' or its corresponding type declarations.
TypeScript
0 vote159 views1 answer
Mat-nav-list' is not a known element angular 9
TypeScript
0 vote161 views4 answers
Craeting a method that can take any number of arguments in python
TypeScript
0 vote172 views1 answer
Aruments in C#
TypeScript
7 votes162 views2 answers
Conditional inline style angular
TypeScript