Date Format

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!
>--Original Message--
>Ibrahim,
>See if the following article helps:
>http://www.karaszi.com/sqlserver/info_datetime.asp
>--
>Anith
>
>.
>