SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

TRUNC Date Functions

suman amaraApr 10 2014 — edited Apr 10 2014

Hi Team,

I have some confusion about the TRUNC Date function..

select trunc(to_date(sysdate,'dd-mm-yy'),'W') from dual;

oputput

------

TRUNC(TO_DATE(SYSDATE,'DD-MM-YY'),'W')

--------------------------------------

08-04-14

As 'W' unit value is for Same day of the week as the first day of the month

sysdate is 10-April-14 same day of the week should be 07-04-14 ,why it showing 08-04-14?

Locked Post

New comments cannot be posted to this locked post.

Locked on May 8 2014

Added on Apr 10 2014

5 comments

1,091 views