Date time as expressed by BOL
quote:
Values with the datetime data type are stored internally by Microsoft SQL Server as two 4-byte integers. The first 4 bytes store the number of days before or after the base date, January 1, 1900. The base date is the system reference date. Values for datetime earlier than January 1, 1753, are not permitted. The other 4 bytes store the time of day represented as the number of milliseconds after midnight.
in otherwords it is stored as a number not as text or a specific format.
You can enter most commonly accepted formats and can control the format based on SET DATEFORMAT. As for the look of the data being retrieved it can be express in many prefined formats using CONVERT (see BOL) or by using datepart funtionality to parse into your own customer format.
As for your question of the 2 values you gave, the answers is yes they will be equal. 5409045121009 demonstrates this with his code example.