Oh well, for now I am just running a query to see what day the database is using as the 'first day of week', and code my logic accordingly. But I hope, someone can point out the 'best practice' for something like this.
Thanks for the input, guys
Joined: Aug 15, 2004
we both are gettin "6, Friday" with Oracle client. so, the problem is why you are gettin 5 when using jdbc.
yeah we can set the value for NLS_LANG parameter for oracle. probably you can find that parameter in your database parameter file. under /ORAHOME/..
wish you luck
subject: Strange behaviour when using Oracle TO_CHAR to get day of week