/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 vote218 views1 answer
District affected by latur earthquake
TypeScript
6 votes265 views4 answers
Property 'style' does not exist on type 'Element'.ts(2339)
TypeScript
0 vote254 views1 answer
The softness of a spot lights edge is controlled by penumbra angle, value gives perfect hard edge:
TypeScript
1 vote249 views1 answer
Typescript var global: typeof globalThis
TypeScript
1 vote240 views1 answer
A function that prints all numbers from 0 - n Added together python
TypeScript
1 vote269 views1 answer
Vue router mode history typescript
TypeScript
0 vote243 views1 answer
Typescript implement
TypeScript
-1 vote229 views1 answer
Body massage centers in kochi
TypeScript
2 votes238 views2 answers
How to input elements in list in python using for loop
TypeScript
5 votes236 views1 answer
Extends vs implements java
TypeScript