Posted by Jim Andersen on 01/04/07 08:47

Sql server 2000 -> sql query analyzer
select datename(dw,'01-01-2006')

returns sunday

Now I do:
set language danish
select datename(dw,'01-01-2006')

returns sonday. But it should be s�ndag. Same goes for
saturday/lordag/l�rdag

Tried substring'ing and ascii'ing/unicode'ing and it is AFAIK an o instead
of the special danish character �.

Is this a "feature" or am I doing something wrong?

I "solved" it by doing
select case DATENAME(dw,'01-01-2006') WHEN 'lordag' THEN 'l�rdag' WHEN
'sondag' THEN 's�ndag' ELSE DATENAME(dw,'01-01-2006') END

but it sure aint pretty.

/jim

• Next in forum: Re: Script to combine multiple rows into 1 single row
• Prev in forum: Re: Merge Replication and Trigger Problem
• Thread view: Weekday names

[Reply to this message]