/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 vote241 views1 answer
Apexcharts dataURI style
TypeScript
1 vote211 views1 answer
Next api typescript
TypeScript
-1 vote212 views1 answer
"gcm_sender_id":"15057814354"
TypeScript
0 vote214 views1 answer
Typescript vue html css types
TypeScript
9 votes213 views5 answers
Array of objects typescript
TypeScript
17 votes232 views4 answers
Pygame mouse events
TypeScript
0 vote213 views1 answer
Sort a list of ints python in descending order
TypeScript
1 vote202 views1 answer
Sort list of objects by attribute java
TypeScript
0 vote231 views2 answers
Qml tableview dynamic
TypeScript
8 votes204 views5 answers
Google fonts cdn link
TypeScript