title: Snowflake chooses timestamp format over date format on load of CSV
body: <p>I have a <code>CSV</code> with a column containing basic dates (like 01/11/2020).</p>
  
  <p>I have specified in the <code>FILELOADER</code> the following format specifications:</p>
  
  <ul>
  <li><code>DATE_FORMAT = 'MM/DD/YYYY'</code></li>
  <li><code>TIMESTAMP_FORMAT = 'MM/DD/YYYY  HH24:MI'</code>.</li>
  </ul>
  
  <p>This should create a match for the date columns using the <code>DATE_FORMAT</code>.  However, <code>Snowflake</code> sees the date column and identifies it as a timestamp column.  Since no time exists in that column it fails to match the <code>TIMESTAMP_FORMAT</code> and the load fails.</p>
  
  <p>Why is <code>Snowflake</code> choosing to identify my date column as a timestamp column?</p>
  
  <p>Here is the full FILE FORMAT specification I am using:</p>
  
  <pre><code>CREATE OR REPLACE FILE FORMAT jobstats_csv_format
    TYPE = CSV FIELD_DELIMITER = ',' SKIP_HEADER = 1 NULL_IF = ('NULL', 'null') EMPTY_FIELD_AS_NULL = true COMPRESSION = AUTO FIELD_OPTIONALLY_ENCLOSED_BY='"' DATE_FORMAT = 'MM/DD/YYYY' TIMESTAMP_FORMAT = 'MM/DD/YYYY  HH24:MI';
  </code></pre>
  
  <p>... this file format specification is referred to in my stage definition ...</p>
  
  <pre><code>CREATE OR REPLACE STAGE tct_jobstats_input_stage
    URL='azure://blahblahblah.blob.core.windows.net/tct-filefly-input/'
    CREDENTIALS=(AZURE_SAS_TOKEN='blahblahblahblahblah')
    FILE_FORMAT = jobstats_csv_format;
  </code></pre>
  
  <p>... and the code I am using to load it...</p>
  
  <pre><code>    try 
      {
          var load_cmd  = "COPY INTO LifelineRemoved ";
              load_cmd += "FROM @tct_jobstats_input_stage ";
              load_cmd += "PATTERN='.*Lifeline Removed During Date Range.*[.]csv.*';";
          var load_stmt = snowflake.createStatement( { sqlText: load_cmd } );
          load_stmt.execute();
      }
      catch (err)
      {
          result =  "Failed: Code: " + err.code + "\n  State: " + err.state;
          result += "\n  Message: " + err.message;
          result += "\nStack Trace:\n" + err.stackTraceTxt; 
      }
  </code></pre>
  
  <p>... and here is a (header + single) line of data from the CSV which fails to load.
      account,customerstatus,certifieddate,lifelineremoveddate,lifelineremovedreason,telephonenumber1,linestatus,activationdate,disconnectdate,firstname,lastname,serviceaddress1,serviceaddress2,servicecity,servicestate,servicezip,Column1
      123456,Active,11/26/2019,12/1/2019,DSN D Denied 90-5 The customer has had their LifeL,(321) 5551212,Active,11/26/2019,,JOHN,DOE,1524 EXAMPLE ST,,FRESNO,CA,93706,</p>
  
  <p>... and finally the error I am seeing...
  <a href="https://i.stack.imgur.com/Trd52.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Trd52.png" alt="enter image description here"></a></p>