Re: Date setting - newbie

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 02/20/04 

Date: Fri, 20 Feb 2004 09:54:53 +0100

SQL Server doesn't store date with any formatting at all, the internal
representation is in a type of binary representation.

The rules for how a datetime string is interpreted is rather complicated.
Some formats are dependent on SQL Server settings such as SET DATEFORMAT,
LANGUAGE. While other are language neutral (like the unseparated format
'YYYYMMDD').

As for output, the date is not returned in any format when it leaves SQL
Server. It is the client applications which formats the date, possibly
depending on the regional settings. 

-- 
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"K.K." <someone@microsoft.com> wrote in message
news:uV2ELU19DHA.2184@TK2MSFTNGP09.phx.gbl...
> Hi all,
>
> Can anyone tell me how can I change the default date fromat from
mm/dd/yyyy
> to dd/mm/yyyy?
>
> If I change the date format setting, will the server update all records to
> the new format as well?
>
> Thanks,
>
> K.K.
>
>

Relevant Pages

  • Re: mm/dd/yyyy format question
    ... I was not talking about how .Net or SQL Server stores date/time values ... I get the impression that you are talking about ISO 8601 in terms ... applications use the format for unambiguously representing date/time ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Querying on dates in dd/mm/yyyy hh/mm/ss format using Access2002 And SQL Server 7
    ... For parsing a string to a date/time, the 103 format doesn't limits the user ... > which is used as the row source for the results form). ... > other solutions assuming I have to use SQL Server 7? ... > I don't understand how I can use parameterized stored procedures to solve ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Moving a VBA function to SQL server
    ... "String Functions " in Books Online. ... The SQL server database contains a table named 'WorkOrders'. ... This will produce a job header formatted like this: ... The format he specifies is stored in table 'Settings' - field 'JobHdrMask' ...
    (comp.databases.ms-access)
  • Re: unicode textbox problem
    ... I get the data in the above format from SQL server. ... If I move the same data into an asp:textbox, or an html input textbox, I ... But I need this to show the Chinese characters. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: mm/dd/yyyy format question
    ... "what is the logical way to configure server, sql server or program so ... it always deals with date as mm/dd/yyyy format". ... ISO 8601 specific to Asian countries? ... If the original question had been about what .Net classes/objects to ...
    (microsoft.public.dotnet.languages.vb)
Loading