SELECT
    0.25 AS col1
INTO #v;

EXECUTE 
    tempdb.sys.sp_columns
        @table_name = N'#v',
        @table_owner = N'banana',
        @table_qualifier = N'tempdb',
        @column_name = N'col1';

DROP TABLE #v;

SELECT CAST(25e-2 AS datetime);

DECLARE @f float = 25e-2;
SELECT CAST(@f AS datetime);

DECLARE @dt datetime = '1900-01-02 00:00:00.006';
SELECT @dt;
SELECT CONVERT(binary(8), @dt);