title: how to cast datetime2 as datetime
body: <p>I'm trying to convert datetime2 to datetime in order to create a standard between different sources using only SQL or SSIS
  Take the following SQL query as example:</p>
  <pre><code>SELECT CAST(offer_start_date AS timestamp)
  FROM [ODS].[macaclient_offers]
  </code></pre>
  <p>I get the following error:
  'Explicit conversion from data type datetime2 to timestamp is not allowed.'</p>
  <p>Furthermore, I did managed to convert datetime2 into date using a simple cast.</p>
  <p>What is the right way to convert datetime2 to datetime using SQL Server 2008 or SSIS?</p>
  <p>gilibi</p>