title: How to insert data in the form of dd/mm/yyyy hh:mm in snowflake
body: <p>Everyone I have the data in the source system as '<strong>dd/mm/yyyy hh:mm</strong>' so i thought of using datetime in snowflake, but the documentation says that the format is '<strong>dd/mm/yyyy hh:mm:ss</strong>' so it throws me an error stating that</p>
  <blockquote>
  <p>Timestamp '01/02/2009 04:53' is not recognized</p>
  </blockquote>
  <p>so in this scenario what should i do in order to store the data in snowflake if the source system is in this format.</p>
  <p><strong>Possible solutions that i have found out is:</strong>
  **</p>
  <ul>
  <li>1: Store the data of the column in the format of 'varchar(x)' of fixed length, which
  might be a good solution but, is there any other alternative to store
  the data as datetime without converting it into 'varchar(x)'.</li>
  <li>2: varchar(x) is the datatype of the timestamp with length 'x' which is <strong>'dd/mm/yyyy hh:mm:ss'</strong>.</li>
  </ul>
  <p><strong>The Schema Looks like this:</strong></p>
  <ul>
  <li>1: Sample schema of the table is<br />
  <strong>CREATE TABLE T1(ID INTEGER,TRANSACTION_DATE DATETIME)</strong></li>
  <li>2: Here is the link for reference, to the datatype manual in snowflake.
  (<a href="https://docs.snowflake.com/en/sql-reference/data-types-datetime.html#datetime" rel="nofollow noreferrer">https://docs.snowflake.com/en/sql-reference/data-types-datetime.html#datetime</a>)</li>
  <li>3: Newbie Here, Please pardon me,if there are any typo's ! thanks in advance.
  **</li>
  </ul>