Toolbox sql-server-lDateTime in SQL is stored in just two integer numbers. There are two 4-byte integers stored. But they are packed together into a BINARY(8). The first 4-byte being the elapsed number days since SQL Server's base date of 19000101. The Second 4-bytes Store the Time of Day Represented as the Number of Milliseconds After Midnight.
Further depending on the language set in your database (normally english) you have to format Dates accordingly. For the english language format this is: MM/DD/YYYY and to change the format refer to this KBA link.
*Extracts taken from net.

You have two option to format date in sqlserve :-
1.Use Convert.ToDateTime(<Datevalue>,<Format>)
2.Use Cast(string AS Datetime)
Note:- Basically cast is used to cast a type to another type.Better to use
convert for change the format.