Re: DateTime

From: Gregory A. Larsen (greg.larsen_at_netzero.com)
Date: 07/01/04 

Date: Thu, 1 Jul 2004 16:51:31 -0700

I'm not sure what you are trying to do, but I don't think you want to mess
with your language setting. The "set language" command is only in affect
for the session. What I really think you need is to use the "set
dateformat" statement to control the format of your input data. Sorry for
the confusion. Something like this:

create table x(d datetime)
set dateformat dmy
insert into x values ('30/06/2002')
set dateformat mdy
insert into x values ('09/30/2002')
select * from x
drop table x 

-- 
----------------------------------------------------------------------------
----------------------------------------------------------------------------
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Niles" <Niles@discussions.microsoft.com> wrote in message
news:5F4A1DCC-329E-4232-8661-26212099F305@microsoft.com...
> does the set language command do that at the server level or database
level or table level or field level?
> can I change the datetime field in my db table to accept european time?
>
> "Gregory A. Larsen" wrote:
>
> > Have you check what the dateformat for the language you are using.  You
can
> > do this by issuing the following command:
> >
> > sp_helplanguage @@language
> >
> > If you want a different format then your langauge format you can change
it
> > by using the SET DATEFORMAT.
> >
> > Here is an example of where I used two different language.  In these
> > examples us_english like mm/dd/yyyy format and British like dd/mm/yyyy.
> > Hopefully this will give you some ideas on how to fix you problem.
> >
> > set language us_english
> > exec sp_helplanguage @@language
> > create table x(d datetime)
> > insert into x values ('30/06/2002')
> > insert into x values ('09/30/2002')
> > select * from x
> > drop table x
> >
> > set language  British
> > exec sp_helplanguage @@language
> > create table x(d datetime)
> > insert into x values ('30/06/2002')
> > insert into x values ('09/30/2002')
> > select * from x
> > drop table x
> > -- 
> >
>
> --------------------------------------------------------------------------
--
>
> --------------------------------------------------------------------------
--
> > ----
> >
> > Need SQL Server Examples check out my website at
> > http://www.geocities.com/sqlserverexamples
> > "Niles" <Niles@discussions.microsoft.com> wrote in message
> > news:164CBB03-BCA1-41DB-96A9-6739B33547F7@microsoft.com...
> > > I have an application that is sending the date with the following
format
> > dd/mm/yyyy the field in the table in sql is a datetime and the record is
not
> > being inserted.  If I manually change the value in the query analyzer to
> > mm/dd/yyyy the record is inserted successfully.  How can I change the
data
> > type to accept the values as is
> > >
> > > Thanks
> >
> >
> >

Relevant Pages

  • Re: French, German, Italian SQL Query via ADO
    ... conversion) and use only typed values to communicate with the SQL-Server. ... However, with each user account, there is a default language. ... set language english ... I have a SQL query generator which does something like: ...
    (microsoft.public.data.ado)
  • Re: Value Pack in Microsoft word
    ... The set language button under tools does not appear so that I can ... switch to the German language dictionary and grammer checker and ... > Daiya Mitchell, MVP Mac/Word ...
    (microsoft.public.mac.office.word)
  • Re: Dictionary Detecting English Words as Spanish???
    ... and then use Tools, Language, Set Language to ensure that the language is ... Terry Farrell - MS Word MVP ... > So far, I have tried copying the text into a new document, copying into ...
    (microsoft.public.word.application.errors)
  • Re: spellcheck in a form
    ... Tools | Language | Set Language. ... >> Make sur ethe style sin the form do not have No proofing checked. ... >> Steve Hudson - Word Heretic ...
    (microsoft.public.word.docmanagement)
  • Re: DateTime
    ... does the set language command do that at the server level or database level or table level or field level? ... can I change the datetime field in my db table to accept european time? ...
    (microsoft.public.sqlserver.server)