473,412 Members | 2,067 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,412 software developers and data experts.

sqlserver datetime

hi
everyone

i just help regarding set datetime from us format to uk format in sql2000. if can change the settings what should i do ?

below is the code i used :

1) i changed the regional settings of the system. but it didnt work .
2) then i opened the query analyzer and the set datetime as

SET DATETIME dmy
this also didnt work .

so plz anybody can help me regarding this.
Apr 3 '08 #1
1 1353
ck9663
2,878 Expert 2GB
hi
everyone

i just help regarding set datetime from us format to uk format in sql2000. if can change the settings what should i do ?

below is the code i used :

1) i changed the regional settings of the system. but it didnt work .
2) then i opened the query analyzer and the set datetime as

SET DATETIME dmy
this also didnt work .

so plz anybody can help me regarding this.

use CONVERT function. Use the British/French setting.

-- CK
Apr 3 '08 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Stormblade | last post by:
Hey all, I have a web app that uses SQLServer 2000. I am switching to MySQL 4. 1.1. I have re-created all the tables but I'm running into 2 problems. 1. In SQLServer I can create a...
1
by: Akshat | last post by:
Hi. i am facing a problem. How do i save a java.util.Date in a SQLServer column declared as a 'datetime' . and please tell me how to retrieve it too.
3
by: mcod3r | last post by:
i'm using an sqlcommand like this "update mytable set myfielddatetime='" + DatetTime.Now.ToString("G") + "'" but when i execute it, i get an exception (System.Data.SqlClient.SqlException) that...
1
by: virendra.chandra | last post by:
hi guys, this is virendra. I am in big trouble to handle date situation using where clause. i am using ormapper. if the sqlserver and application server has different date format(different...
1
by: Thierry | last post by:
Hi, I've got the next problem: I have a datetime field in my database (sql-server) and I want the option in it that this field can be empty. But if I leave that datetime field empty I get...
5
by: JSParker1 | last post by:
Summary: Maximum number of records per second that can be inserted into SQLServer 2000. I am trying to insert hundreds (preferably even thousands) of records per second in to SQLServer table...
1
by: A.Neves | last post by:
Hi, I'm having a problem, I have a DateTime value in Portuguese representation (dd-mm-yyyy) and I'm using SQLServer2005 with its default language English (yyyy-mm-dd), so when I assemble a WHERE...
1
by: Amit | last post by:
Hello , Is there any way i can import data from datagrid to sqlserver. please advise . thanks & Regards
2
by: raj | last post by:
Hi, I have a table which has a column of type datetime,i want to write a query where i can get only year from my datetime column. 2004-11-16 00:00:00.000 this is the one which i have i...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.