December 14, 2007 at 5:52 am
Hi!
I have a Server 2005 as a local instance and an other one at the network.
The Problem is, that they have different language settings, because of different installations.
So the datetime format is different, when i communicate with vb or .net. Know what i mean?
The formats are german and english. I need the german for booth.
Can I change the setting?
Thanks
Chris
December 14, 2007 at 5:55 am
oh joy! you can set the date formats within the sql scripts using a set option, you can set the language of your users, or you can just extract the dates to iso , I think odbc or use full dates which as far as I know will always work - did some testing with it a couple of years ago.
e.g. 1 january 2007 12:34 and it's german equivilant will always work ( assumimg language set )
failing that add an additiinal column and calculate the dates out to a common use.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
December 14, 2007 at 5:55 am
One way of handling that in vb or .net is to use variables declared as DateAndTime.
Don't stuff it into strings, ... but use the corect variable-datatype.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply