title: add extra columns in a SELECT INTO statement
body: <p>I am doing a SELECT INTO statement to create a new table from some values in another table. I want to add two extra columns onto the newly created table (pol_eff_dt, pol_exp_dt) and make them all NULL initially (these columns also exist in the source table so they would otherwise pull that data). I also need to make sure they come over as DATETIME types. How can I cast them this way? I've tried a lot of things, but nothing will compile.    </p>
  
  <pre><code>SELECT DISTINCT bnd_ser_nbr,
  trans_nbr,
  uws_product_cd,
  bill_id,
  NULL AS pol_eff_dt, 
  NULL AS pol_exp_dt
  INTO ER_RO_urs_prem_detail
  FROM urs_prem_detail_interim
  </code></pre>