SQL Server Date is very simple

Hi Guys,
Working with DateTime in SQL Server is very simple here is the the tip
Insert Date In SQL Server Table:

Create Table DateTable( DateColumn varchar(8)) go
/* Inserting the test value into the table */
insert into DateTable select '19780129'
insert into DateTable values ('January 1, 2000')
insert into DateTable values (getdate()) – getdate() means current date

To Enter Dates in different styles Microsoft Has provided some style codes
(Stay Tuned)