Date Format

From: Ibrahim Awwad ("Ibrahim)
Date: 08/12/04 

Date: Thu, 12 Aug 2004 03:03:02 -0700

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|
|-----------------------------|

Relevant Pages

  • Missing tools in SSMS 2005
    ... I am using SSMS since a few weeks, and I found it is missing a few tools/utilities from the old Query Analyzer. ... The worst of all, anyway, is that we still can't apply a customized format to the sql documents. ... Get me right, so far my experience with SMSS has been positive, only these and other little defaillances are marking the difference between an useful tool and a tool to recommend. ...
    (microsoft.public.sqlserver.tools)
  • Re: A mindboggingly basic question
    ... there are limitations with Query Analyzer regarding column ... > I'm very new to being an SQL DBA (I'm an MS Access and Cold Fusion ... > where we're going to be pushing out data in XML format. ... > a text format. ...
    (microsoft.public.sqlserver.xml)
  • Re: How to retrieve query results with now field names, dotted line or footer
    ... format in query analyzer. ... Output Format and see if one of the format options will meet your ... query analyser but will just have the data with no column names, ...
    (comp.databases.ms-sqlserver)
  • Re: Problem querying SQL Server View as mail merge source
    ... but you can try a date format of 'YYYY-MM-DD': ... > Data Access Components" ... > .MainDocumentType = wdNotAMergeDocument ... If I paste the query into Query Analyzer, ...
    (microsoft.public.access.adp.sqlserver)
  • Date format
    ... I have a table that one of its column is in dateTime ... My date format in the pc is dd/mm/yyyy (in the Regional ... In the Query Analyzer I run "SET DATEFORMAT DMY" but when ...
    (microsoft.public.sqlserver.server)