toad - Start of the Week from SQL Developer and CMD is different -


i have been executing sql query give me previous weeks transactions toad condition transdate between trunc(sysdate,'day')-7 , trunc(sysdate,'day')-(1/24/60/60). consider week starting monday sunday. has been working fine our team.

i running sql file through cmd batch file considering week sunday saturday. not in sync sql file when executed in toad or sql developer. please can me how fix issue?

thanks yashodhan


Comments

Popular posts from this blog

vue.js - Create hooks for automated testing -

php - Vagrant up error - Uncaught Reflection Exception: Class DOMDocument does not exist -

serial port - hub4com OVERRUN Error -