title: SQL Server 2008 Creating Table with date column with specified format
body: <p>I have to create a table with 3 columns as (dtFrom, dtTo, service_time). 
  dtFrom &amp; dtTo is datetime , service_time is int. Now in datetime column I have to save date as 22-Apr-2018. How should I set format in CREATE TABLE query.</p>
  
  <p>I have googled it but didn't found any help.</p>
  
  <p>Below is CREATE TABLE query:</p>
  
  <pre><code>create table tbl_previous_policy
  (
   dtFrom datetime NOT NULL,
   dtTo datetime NOT NULL,
   service_time int NOT NULL
  )
  </code></pre>
  
  <p>Now how should I set the format for datetime columns in above query?</p>