Skip to Content
0
Mar 04, 2016 at 12:58 PM

MS SQL Time Data Type Precision

50 Views

hello everyone,

I'm trying to reverse a database with a table with a field of type "time(5)",

the pdm imports it as data type "time" without precision (or length) specifier.

when I try to update database from pdm, it want to modify my physical field to "time"

I have tried to modify DBMS Properties adding

T%n -> time(%n) in MSSQLSRV2012::Script\DataType\AmcdDataType

time(%n) -> T%n in MSSQLSRV2012::Script\DataType\PhysDataType

but nothing happens 😔

how can I handle this data type?

I thought the problem could be that Standard Data Type for Time does not have size/precision enabled.

Is it possible to enable the grayed out field for Time precision in Standard Data Type dialog?

thank you