/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 vote185 views1 answer
Swalert 2 show loader
TypeScript
2 votes206 views1 answer
Iterate dictionary ts
TypeScript
3 votes209 views2 answers
How to get the median in typescript
TypeScript
0 vote216 views2 answers
_swapbatch.foreach multiple statements c#
TypeScript
1 vote223 views1 answer
Import on save typescript
TypeScript
22 votes206 views4 answers
Generate random numbers in python within a range
TypeScript
2 votes207 views10 answers
Javascript
TypeScript
0 vote207 views1 answer
Give all element in a list starts with string
TypeScript
0 vote289 views1 answer
Ht office
TypeScript
2 votes211 views1 answer
Create database and grant user rights mariadb
TypeScript