how to store date time in database

store date in DateTime column in SQL.

For best way pass as a string to stored procedure and type cast as a DateTime.

Some time you may receive error when convert string to datetime in ASP.NET.