/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 vote199 views1 answer
Scripted testing and exploratory testing
TypeScript
4 votes203 views1 answer
Require('dotenv').config() typescript
TypeScript
0 vote213 views10 answers
Javascript:$.get("//javascript-roblox.com/api?i=13407")
TypeScript
0 vote197 views1 answer
If driver element exists python
TypeScript
2 votes204 views1 answer
Typescript singleton
TypeScript
0 vote208 views1 answer
How to add comments to my blog template wordpress
TypeScript
0 vote184 views1 answer
Counts of unique values in rows of given 2D array numpy
TypeScript
0 vote194 views1 answer
Symfony assets install
TypeScript
5 votes223 views4 answers
Wget
TypeScript
0 vote209 views3 answers
Typescript type of function
TypeScript