/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 vote134 views1 answer
Howt o make sure its a valid sudoku in python
TypeScript
0 vote102 views1 answer
Change event doesn't work on dynamically generated elements .
TypeScript
0 vote97 views1 answer
The following TestContainer was not found
TypeScript
0 vote99 views1 answer
R merge list
TypeScript
0 vote106 views1 answer
What are the used of curly brackets in react functions
TypeScript
0 vote108 views1 answer
Onblur typescript
TypeScript
0 vote98 views1 answer
View and navigate your assignments (teacher) code for asp.net
TypeScript
1 vote103 views1 answer
How to target all child elements css
TypeScript
0 vote129 views2 answers
Linux bash scripts tutorial
TypeScript
0 vote106 views1 answer
Attend
TypeScript