August 18, 2005 at 1:45 am
Do you know to change time setting format to regional setting?
i have problem like this:
esspecially about time and i want to change may into Mei, because i live in indonesia.
anybody to solve this problem??
August 18, 2005 at 7:13 am
SQL server uses the same native way to store datetime data (8bytes decimal). There is no "format".
If you mean the datatime format for query output, you can try the following:
SET LANGUAGE Français
select convert(nvarchar(100),getdate(),106)
SET LANGUAGE us_english
select convert(nvarchar(100),getdate(),106)
GO
August 18, 2005 at 8:19 am
that's rigth i make it for query output
by the way, do you how to know the list of country from MS SQL Server. Are Just us_english and Francais there? how about Indonesia or malaysia???
do you have any idea???
August 19, 2005 at 6:55 am
you can run sp_helplanguage
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply