DT_DATE
Column after converting it to a 8-byte floating-point number DT_R8
.DT_DATE
column42948.123
to 2017-08-01 02:57:07.000
42818.7166666667
to 2017-03-24 17:12:00.000
CAST
will be faster than CONVERT
if you have a large amount of data, also remember to subtract (2) from the excel date:datetime
value to int
and add 1
: