/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 vote402 views1 answer
How to return a new string with its first and last characters swapped
TypeScript
1 vote269 views1 answer
Undefined string typescript
TypeScript
0 vote349 views3 answers
Please make sure you have the correct access rights and the repository exists.
TypeScript
0 vote291 views1 answer
How to add bootstrap to angular app page
TypeScript
2 votes315 views1 answer
Number of elements in c++ array
TypeScript
1 vote330 views2 answers
Docker An attempt was made to access a socket in a way forbidden by its access permissions.
TypeScript
3 votes326 views1 answer
Typescript pass a function as an argunetn
TypeScript
0 vote323 views0 answer
TypeScript
0 vote375 views5 answers
[email protected]
TypeScript
1 vote356 views1 answer
Python lists union
TypeScript