Recent content by Sandeep Kumar

Dezsoe many thanks for your kind advise. Using that I am able to resolve my problem: To get start of week as Monday i.e. same setting as server on which application is installed then following can be used: ALTER SESSION SET NLS_TERRITORY='FRANCE'; select trunc(sysdate, 'day') from dual...

At UNIX or OpenVMS server (which is installed by Oracle DBA and on which my project application is running) if I run select TRUNC(sysdate, 'day') from dual Output is 5th Sept 2011 (Monday) I have checked onhttp://www.techonthenet.com/oracle/functions/trunc_date.php and as per that it should...