Need list of Default Value or Binding for SmallDateTime

[Rx_]

Looking for a list of exmples for SQL 2010 values to enter into Datatype: smalldatetime Default Value or Binding field

It appears that getdate() will bring in the date time when the record is created.
And that timestamp will update the date every time the record is changed.

Looking for a list of examples to put into the Default Value or Binding.

 

[SQL_Hell]

CREATE TABLE customer
(First_Name char(50),
Last_Name char(50),
Birth_Date datetime default GETDATE())

Or

ALTER TABLE Customer
ADD CONSTRAINT [DF_CreateDate] 
DEFAULT GETDATE()
FOR Birth_Date

 

[Rx_]

Thanks,
Found this list on MSDN under Date and Time Data Types and Functions (Transact-SQL)
http://msdn.microsoft.com/en-us/library/ms186724.aspx
It includes the End of Month, date-time offset, and the others to replace the MS Access types with.