/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

1 vote247 views1 answer
How to make a button that alerts when clicked with html
TypeScript
0 vote261 views1 answer
The following TestContainer was not found
TypeScript
2 votes245 views1 answer
Type casting in typescript
TypeScript
1 vote259 views1 answer
Ts class static function call inside class extends
TypeScript
0 vote251 views1 answer
Google sheets mode text
TypeScript
27 votes253 views4 answers
How to hide bullet points in css
TypeScript
1 vote258 views1 answer
Typescript var global: typeof globalThis
TypeScript
0 vote230 views1 answer
Multiline comments coding
TypeScript
0 vote259 views1 answer
Mysql workbench an apparmor policy prevents this sender
TypeScript
0 vote256 views2 answers
Typescript convert to javascript
TypeScript