Thanks a lot that has helped a bunch.

Regards

Martyn Luck

The PCMS Group plc
PCMS House
Torwood Close
Westwood Business Park
Coventry
CV4 8HX

Tel: 024 76694455
Fax: 024 76421390
Mobile: 07803 205653
Copyright (C) 2000 The PCMS Group plc



-----Original Message-----
From: Joe Ingle [mailto:Joe@k...]
Sent: 20 July 2001 12:18
To: sql language
Subject: [sql_language] RE: formatting dates


Hi Martyn

Execute on Master through Query Analyser:

select * from master.dbo.syslanguages

To set the default language back to U.K. English, use the following SQL
statements:

sp_configure 'default language', 23

Then it will ask you to reconfigure, execute this:

reconfigure with override

To check what default language a server has installed, use the following SQL
command:

select name ,alias, dateformat
   from syslanguages
      where langid 
      (select value from master..sysconfigures
         where comment = 'default language')

this will set date format to UK i.e. d/m/y

In addition, you can set the session LCID to UK, this is done by puting the
following in your script:

<%Session.LCID = 2057%>

Also have a look at the 'SET DATEFORMAT' options you have to run before your
SQL Statement, i.e:

mySQL = "SET DATEFORMAT dmy " & vbCRLF & "INSERT INTO blah_table VALUES
"'blah'"

Hope this helps

Joey