| Stephen Rice 2005-12-22, 1:23 pm |
| The first thing Id do is confirm the option is working by setting it
permanently and then restarting the server. If it still doesn't work it
sounds like a bug so please report it through the report a bug web page.
If it does work then post the exact statements and we'll see what we can
figure out
/steve
Hans Peter Oechslin wrote:
> ASA Version 9.0.2.3207
>
> After setting the database option first_day_of_week to 1 (Monday) I still
> get 2 for 2005-12-19
>
> select dow('2005-12-19') Result: 2
>
> Circumstances:
> I have to convert a Stored Procedure from MS SQL to ASA. In SQLServer I
> just have to use SET datefirst 1 to get the required result.
>
> Is there a solution to solve this without writing a function to correct
> that behaviour?
>
> Any help appreciated.
>
> Hans Peter Oechslin
--
Stephen Rice
Technical Services Manager
iAnywhere Solutions
--- Please Post ---
Whitepapers, Tech Docs, Solved Cases, Bug Fixes and
"Report a bug" are all available on www.ianywhere.com
|