title: My "data default (getdate())", it doesn't work
body: <p>I'm trying to insert in my SQL Server table the current date.</p>
  
  <p>My table includes 3 files:</p>
  
  <pre><code>CREATE TABLE [dbo].[MyTable] 
  (
       [Id]   INT IDENTITY (1, 1) NOT NULL,
       [Name] NVARCHAR (50) NOT NULL,
       [Date] DATE 
           CONSTRAINT [DF_MyTable_Date] DEFAULT (getdate()) NOT NULL,
  
       CONSTRAINT [PK_MyTable] PRIMARY KEY CLUSTERED ([Id] ASC)
  ) 
  </code></pre>
  
  <p>When a new user wants to register in the system, he has only to insert his name. </p>
  
  <p>In my table, the Id is generated automatically and the date too, but the date shows <code>01/01/0001</code> instead of the current day.</p>
  
  <p>Where is the mistake?</p>