sqlserver datetime

[nickyspace]

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.

[ck9663]

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