Question about time format in SQL server 2008

I heared from someone that you can adjust one of SQL server settings in order to make deal with (time) datatype as a 12-hour system instead of 24-hour system ??

is that true ?

if is开发者_如何学C it , then how can I do it ?? cuz I need it badly

SQL stores it date format in the same way regardless of local date time formats

Have a look at this link on using the convert function for date and time if you just need to display in a particular format http://www.mssqltips.com/tip.asp?tip=1145