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 on http://www.techonthenet.com/oracle/functions/trunc_date.php and as per that it should be 5th Sept 2011 (Monday)
But if I run same query on PL/SQL developer or Toad or Oracle SQL plus output (which are installed on windows env and have Oracle 9i installed by me on my local machine) is 4th Sept 2011 (Sunday)
Can you please suggest why on TOAD I am getting 4th Sept 2011 (Sunday)?
Also, can you please advise if there is some setting which I should make in windows so that I get output same as UNIX or OpenVMS OS?