/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 vote315 views1 answer
The Effects of Boredom, Loneliness, and Distress Tolerance on Problem Internet Use Among University Students
TypeScript
0 vote309 views1 answer
Custom api endpoints jwt token
TypeScript
0 vote329 views1 answer
Group objects in javascript
TypeScript
0 vote297 views1 answer
Error TS2304: Cannot find name 'EventEmitter'.
TypeScript
1 vote327 views1 answer
Ng-select disabled
TypeScript
3 votes308 views3 answers
How to get value from autocomplete material ui
TypeScript
0 vote321 views1 answer
Capitalize first letter of all word typescript
TypeScript
0 vote301 views1 answer
Check if an element exists laravel
TypeScript
0 vote303 views1 answer
How to parameterize test cases
TypeScript
-1 vote347 views1 answer
Mysqli_fetch_row() expects parameter 1 to be mysqli_result, boolean given in
TypeScript