Problem with 8.1.65, EF6 and TimeStamp with Timezone default values
Posted: Fri 10 Jan 2014 09:51
Using code-first migration with adding new column of type: timestamp with timezone
generates script with invalid default value like this:
As you can see there is an invalid fractional digits (FF3) instead of FF7
Further changing the precision to 3
is causing generation of another invalid script:
In this case is the "count of zeros" still 7.
We are working with Oracle 12c and Entity Framework 6.
Version 8.1.55 is working (no default values)
The resulting Oracle error is
Code: Select all
AddColumn("dbo.RELATION_GROUP", "END_TIMESTAMP", c => c.DateTimeOffset(nullable: false));
Code: Select all
ALTER TABLE ICO_RELATION_GROUP
ADD END_TIMESTAMP TIMESTAMP(7) WITH TIME ZONE DEFAULT TO_TIMESTAMP_TZ('1900-01-01 00:00:00.0000000 +00:00', 'yyyy-mm-dd HH24:MI:SS.FF3 TZH:TZM') NOT NULLFurther changing the precision to 3
Code: Select all
AddColumn("dbo.RELATION_GROUP", "END_TIMESTAMP", c => c.DateTimeOffset(nullable: false, precision: 3));Code: Select all
ALTER TABLE ICO_RELATION_GROUP
ADD END_TIMESTAMP TIMESTAMP(3) WITH TIME ZONE DEFAULT TO_TIMESTAMP_TZ('1900-01-01 00:00:00.0000000 +00:00', 'yyyy-mm-dd HH24:MI:SS.FF3 TZH:TZM') NOT NULLWe are working with Oracle 12c and Entity Framework 6.
Version 8.1.55 is working (no default values)
The resulting Oracle error is
ORA-01830: date format picture ends before converting entire input string