schemazen
schemazen copied to clipboard
Datetime2/datetimeoffset seconds precision is not scripted
Hi!
Script from managment studio:
CREATE TABLE [dbo].[Document]( ... [CreatedDate] [datetime2] (3) NOT NULL, ...
Script from schemazen: CREATE TABLE [dbo].[Document]( ... [CreatedDate] [datetime2] NOT NULL ...
As a result column is created with default precision - 7.
Same behaviour for datetimeoffset