SQL SERVER 2000: In Which Format The Datetime Will Be Stored In Sql Server 2000?

Hi All,

I would like to know, how the datetime will be stored in the sqlserver datetime column.

Because some time i am giving the date in dd/mm/yyyy and sometime mm/dd/yyyy.

while give the date in mm/dd/yyyy works fine but not in the another case. and also while i execute a query on query analyser it shows the datetime in

yyyy/mm/dd format.

So anyone can please tell me how the dates will be stored in the datetime column of sqlserver database?

Thanks in Advance.

Regards,

Dhanasekaran. G