/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 vote142 views1 answer
How to compra vales on lists python
TypeScript
9 votes145 views3 answers
Angular append array to another
TypeScript
1 vote144 views1 answer
Cannot find module jquery typescript ionic
TypeScript
0 vote138 views3 answers
Typescript with babel
TypeScript
1 vote178 views1 answer
Cannot read property 'slideTo' of undefined TypeError: Cannot read property 'slideTo' of undefined
TypeScript
5 votes134 views2 answers
How many states of matter are there
TypeScript
0 vote133 views1 answer
How to get ppt screen shots from a video using python :: keyframes
TypeScript
7 votes148 views2 answers
How to download torrents in ubuntu
TypeScript
0 vote161 views1 answer
Google sheets find last cell with value in range
TypeScript
1 vote150 views1 answer
Python get elements from list of dictionaries
TypeScript