/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

-4 votes151 views1 answer
Whats a group of pandas called
TypeScript
0 vote141 views1 answer
'mat-icon' is not a known element:
TypeScript
0 vote149 views1 answer
Arranging array objects in custom order
TypeScript
0 vote148 views1 answer
Sort a list of ints python in descending order
TypeScript
1 vote144 views1 answer
What is the name of belt around the orbits of earth and mars
TypeScript
0 vote137 views1 answer
Use sample weights fit model multiclass
TypeScript
0 vote138 views1 answer
Spyon observable
TypeScript
1 vote134 views1 answer
Luxon sql datetime
TypeScript
0 vote186 views1 answer
How to show array of objects in flatlist react native
TypeScript
1 vote146 views3 answers
Typescript check undefined
TypeScript