/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 vote273 views1 answer
Serenity-is change button text
TypeScript
0 vote300 views1 answer
Group list into sublists python
TypeScript
3 votes353 views2 answers
@ts ignore file
TypeScript
41 votes367 views3 answers
Get last n elements from list java
TypeScript
0 vote242 views1 answer
GOOGLE SHEETS web scraping commodity prices 2021
TypeScript
0 vote275 views2 answers
Object map of the http parameters mutually exclusive with fromString
TypeScript
1 vote290 views1 answer
Cmd check if folder exists or not
TypeScript
1 vote292 views1 answer
Mat input datetime-local now
TypeScript
1 vote278 views2 answers
Docker An attempt was made to access a socket in a way forbidden by its access permissions.
TypeScript
0 vote282 views2 answers
Paragraph dots after 2 lines css
TypeScript