/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 vote263 views1 answer
.htaccess Forcing scripts to display as source code
TypeScript
1 vote263 views1 answer
How to set the contents of a div with jquery
TypeScript
0 vote280 views2 answers
Comparison method violates its general contract!
TypeScript
0 vote306 views1 answer
How to add 3d objects folder to this pc windows 11
TypeScript
1 vote316 views2 answers
Solitaire
TypeScript
51 votes428 views6 answers
Duplicate in sql
TypeScript
3 votes297 views1 answer
Ts reverse array
TypeScript
2 votes281 views2 answers
Capacitor icon and splash
TypeScript
0 vote276 views1 answer
Arranging array objects in custom order
TypeScript
0 vote311 views1 answer
Pdfunite all documents in a folder with alphabetical order
TypeScript