how to store date time in database

Question

Hi How to show date in text box like 12/27/2012 03:14 PM using calender extender and how to stroe this date in databse

Dinesh Bhat · Answer

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.