how to cast datetime2 as datetime

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:

SELECT CAST(offer_start_date AS datetime)
FROM [ODS].[macaclient_offers]

I get the following error: ‘Explicit conversion from data type datetime2 to timestamp is not allowed.’

Furthermore, I did managed to convert datetime2 into date using a simple cast.

What is the right way to convert datetime2 to datetime using SQL Server 2008 or SSIS?

gilibi

Answer

OK, I managed to accomplish that using a SSIS data conversion component. I found out that I can use either DT_DBTIME2 or DT_DBTIME

Thanks for everyone who helped

Advertisement

Answer