Munchlax Pineapples
Munchlax Pineapples
Programming language:TypeScript
2021-03-30 20:20:22
0
Q:

mutiple date formats in snowflake during copy

尤慕李
尤慕李
Code: TypeScript
2021-09-26 17:34:23 
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;
0

Tags

New to Communities?

Join the community