/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 vote135 views1 answer
In order to allow non-dict objects to be serialized set the safe parameter to False.
TypeScript
0 vote150 views1 answer
None of the following functions can be called with the arguments supplied. makeText(Context!, CharSequence!, Int) defined in android.widget.Toast makeText(Context!, Int, Int) defined in android.widget.Toast
TypeScript
0 vote147 views1 answer
DAX check if value exists in another table
TypeScript
1 vote134 views1 answer
Selenium get all child elements python
TypeScript
0 vote154 views1 answer
Python multiply digits of a number
TypeScript
0 vote126 views1 answer
Typescript doesn't know type of HTML element
TypeScript
2 votes139 views1 answer
Requests python no proxy
TypeScript
0 vote143 views1 answer
Loc multiple conditions string and integer
TypeScript
0 vote139 views1 answer
Python fancy way to get arguments from the command line
TypeScript
0 vote136 views1 answer
Indexable type in ts
TypeScript