schemazen icon indicating copy to clipboard operation
schemazen copied to clipboard

Datetime2/datetimeoffset seconds precision is not scripted

Open denisaug opened this issue 7 years ago • 0 comments

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

denisaug avatar Mar 21 '17 11:03 denisaug