Question insert date in sql server database

[sweish]

I have a form consisting of some trextboxes and datetimepicker controls. I want to save the date in sql server database in yyyy-mm-dd or yyyy/mm/dd format. IS it possible?

 

[JohnH]

Start with these:
http://www.vbdotnetforums.com/sql-server/41715-sql-datetime.html
http://www.vbdotnetforums.com/ms-access/40907-uk-style-date.html

 

[sweish]

I didnt get your point clearly. Which datatype should i use in sql server? I want to save date and time seperately in 2 fields. I saw the posts but i didnt understand. I want in database as,

Date time
2010-05-26 17:25:36

In this way it is possible in sqlserver or not?