/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

6 votes151 views1 answer
Typescript replace
TypeScript
3 votes174 views1 answer
Find a value in list of objects in c#
TypeScript
0 vote147 views1 answer
Return tru if one of the objects in a aray has a fild match
TypeScript
0 vote141 views1 answer
Sql server results to comma delimited string
TypeScript
0 vote157 views2 answers
Get only parent child elements beautiful soup
TypeScript
0 vote155 views1 answer
Behaviour
TypeScript
0 vote148 views1 answer
Property 'orderBy' does not exist on type 'AngularFirestoreCollection<DocumentData>
TypeScript
0 vote148 views1 answer
Install typescript mac
TypeScript
0 vote141 views1 answer
Mongo change all documents on field
TypeScript
0 vote175 views1 answer
From the three types of styling, which one is the most useful in terms of website optimization?
TypeScript