sql server mseq: Dear All,,
Date is entered on the table on the format of dd/mm/yyyy. When I see the
table I can see it in correct order ddmmyyyy. In the Query Analyzer, I see it
yyyymmdd. In addition the more seriouse proble is that when I right a
statement to choose an exact date or date interval, I have to enter the date
in format mmddyyyy otherwise the SQL will understand the date in wrong format.

Can any one help on that please.

--
*********
IT Manager
DeLaval Ltd.
Cairo-Egypt
*********
|-----------------------------|
|Islam is peace not Terror|

Ibrahim,

See if the following article helps:
http://www.karaszi.com/sqlserver/info_datetime.asp

--
Anith

That site helps a lot, thanks!
[quoted text, click to view]