|
kman
Starting Member
6 Posts |
 Posted - 04/08/2007 : 07:10:39
|
Hi, I have a problem with the region settings on SQL Server Compact Edition.
To begin with, in my C# Windows Mobile app, I start with fetching records for the current month from SQL Server 2005 Express.
That works without any problems, however, when I try to filter these records locally by weeknumber something happends;
SQL Server CE uses Sunday as the first day of the week, which is inconvenient since I live in Europe 
I tried to "SET DATEFIRST 1" in a query prior to the one fetching weekly records but that just result in an exception.
Does anyone know how to change the regional settings on SQL Server CE? |
Edited by - kman on 04/08/2007 07:11:57
|
|
European weeks in SQL Server CE
