title: How to insert Julian Date in Snowflake Date Datatype field
body: <p>My data is in below format ( Julian):</p>
  <p>2020102
  2019134</p>
  <p>Datatype in Snowflake is Date for this field. How do I insert this in Snowflake using Copy Command.</p>
  <p>I am thinking below but I couldn't find a date format for Julian yet.
  Copy into Table*col1,col2) (select $1,TO_DATE($2,'format') from @%Table</p>