title: How to create and insert record with unix timestamp - sql server 2014
body: <p>I want to create the following table:</p>
  
  <pre><code>user_id     unix_timestamp      platform     Action
     1         1501688421118         IOS         A
  </code></pre>
  
  <p>My create table is:</p>
  
  <pre><code>create table C (
  user_id integer,
  unix_timestamp timestamp,
  platform varchar(50),
  Action varchar(50)   
  );
  </code></pre>
  
  <p>Then I want to insert row:</p>
  
  <pre><code>INSERT INTO C 
  VALUES ('1', 1501688421118, 'IOS','A');
  </code></pre>
  
  <p>I got error, i tried varbinary(8) instead of timestamp but when i am doing the insert, i am binary result in unix_timestamp column instead of 1501688421118.</p>