Posted: Wed Sep 26, 2007 3:17 am Post subject: casting a month in foreign language
Newbie
Joined: 25 May 2007 Posts: 7
In ESQL I try to cast a string into a date variable with a pattern "HH:mm dd MMM yyyy".
The string is parsed from a file that is generated in English i.e. it will look like "18:05 06 Aug 2007". The problem is that the regional options on the Message Broker server (WinXP) are Finnish. So the cast fails because "Aug" is not recognized as a month in Finnish. The date in the file will be in English regardless of environment settings.
Is there any other way to solve the problem other than parsing the string and replacing the English representation of the month with the Finnish representation? I cannot change the regional settings on the server.
The solution should naturally be language independent so that the regional options of the server can be ignored.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum